Sharepoint Designer - is there a way to calculate a date difference in a workflow?

sharepoint date workflow sharepoint-designer datediff
notnot picture notnot · Dec 17, 2009 · Viewed 25.7k times · Source

Maybe I'm just crazy... So, with SPD I can add any time unit to a date and put that into a variable, but I can't seem to find anything that will let me calculate the difference between two dates. "Do Calculation" only lets me pick from numeric values. Am I missing something here? Seems like something which should be obvious.

Answer

Colin picture Colin · Dec 18, 2009

Date comparison is not available "out of the box", but there are some workarounds.

Maybe this article: How to perform date calculations and construct dynamic strings in a SharePoint Designer workflow provides the answer?

Some more related information here: Modifying Date Formats in SharePoint Designer Workflows

Related questions

How to calculate the total days between two selected calendar dates

Let say i have startDate = 7/16/2015 and endDate = 7/20/2015. This 2 dates are stored in a SharePoint list. If user select the exact date with the date in SharePoint list, it can calculate the total days = 2 , which means that without calculate on the …

Read More
Best way to resolve file path too long exception

I created a app that downloads all document libraries in a SP Site , but at one point it giving me this error (I tried looking at google but couldn;t find anything, now if anyone knows any trick to solve …

Read More
Auto number column in SharePoint list

In a SharePoint list I want an auto number column that as I add to the list gets incremented. How best can I go about this?

Read More