So, if you change the formula to =-1/24/60… you’ll notice that the dates and times in the Date for PauseUntil column are exactly one minute before the dates and times in the End Time column. If we divide 1 day by 24 hours and divide 24 hours by 60 minutes, we get 1/24/60 = 0.00069444444. You’ll notice in the screenshot here that there are three different End Times and the calculated column subtracts exactly 24 hours for the = –1 formula. In the Additional Column Settings section, I temporarily entered a formula of =-1, selected Date and Time as the data type, and selected Date & Timeas the format. I selected the Calculated (calculation based on other columns) data type. In the Name and Type section, for the name of the column name I used DateTime for PauseUntil. Note: although the screenshots in this post are from SharePoint 2010, the principles are the same in SharePoint 2007. ![]() The easiest way to calculate the Pause Until date and time was to create it as a calculated column in SharePoint. ![]() It’s easy to use the Pause Until Date activity to pause until the necessary time, but it’s not so obvious how to calculate the date and time ithe workflow needs to pause until. ![]() I recently needed to write a SharePoint Designer workflow to send a reminder email 12-hours before the end of a multiple-day event.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |