Contents
Emails were to be sent on item create, as well as at 8am of the start date, 8am of the end date, and at 8am of an overdue date. To be able to calculate 8am of the start date, I obviously need to get just the date of the start date field, then add 8 hours to it. Sounds simple enough.
I have a requirement to get the day of the week into a workflow variable in a SharePoint Designer Site Workflow. This means I do not have a “Current Item” that the workflow runs on.
How to get datepart string in SharePoint Designer?
This will set the string variable to something like 2010-12-28 according to the ISO format (yyyy-mm-dd). We can now use the Utility Actions for string variables to extract our Year, Month and Day.
When to dump as string in SharePoint 2014?
When dumped “as string”, they show as 2/2/2014 10:17:00 AM. The user could specify the time period for which they needed the equipment, which could be at any point of the day, like from noon-5pm.
If you click the ellipses next to the value option, there’s a selector for current date. You would simply use the set workflow variable action and use the current date or use the add time to date action and set 0 days/hours/minutes/seconds to Today.
Start this from within a SharePoint Designer 2013 workflow to get Current Date and Time. Another easy way is to create in your table a calculated column (type date/time) and use the formula =NOW (). Every time the item is triggered by a workflow, this column is updated.
How to calculate time interval in SharePoint Designer?
Note: Be aware that although the index value in Microsoft SharePoint Designer 2013 is zero-based, values in SharePoint Designer 2010 were indexed starting at 1. Calculates the time interval in minutes, hours, or days between two dates and stores the output in a variable. Removes white spaces from the beginning and end of a string.