All geek questions in one place

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

Maybe I'm just crazy ... So, with SPD, I can add any unit of time to the date and put it in a variable, but I can not find anything that allows me to calculate the difference between the two dates. "Do Calculation" allows me to choose from numerical values. Am I missing something? It seems like it should be obvious.

+3
source share
4 answers

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

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

See here for more information: Change date formats in SharePoint Designer workflows

+2
source

You can use the DATEDIF function of SharePoint lists to set the value of a column and then use it in workflows. I'm sure this will help someone out there -

0
source

SharePoint 2013 " ".

Find Interval Between Dates
Calculates the time interval in minutes, hours, or days between two dates and stores the output in a variable.

https://msdn.microsoft.com/en-us/library/office/jj164026.aspx

0

Handling strings and dates, as well as calculations, is a pain in SharePoint Designer workflows. The links mentioned in Colin are good, but you can also consider embedding C # or vb.net code directly in the SharePoint Designer workflow (without the need for Visual Studio).

I wrote a component that allows you to do this and blog about it at the following URL:

http://www.muhimbi.com/blog/2009/12/embed-c-or-vb-code-directly-in.html

-1
source

Source: https://habr.com/ru/post/1726007/

More articles:


All Articles