Dear Dev Talk:

Any idea on how to get a math operation to return the number of days between two dates instead of the number of seconds? Thanks!

Nintex 2010 on SharePoint 2010 list

Dan

Visit
www.nintex.com

Dear Dev Talk:

Any idea on how to get a math operation to return the number of days between two dates instead of the number of seconds? Thanks!

Nintex 2010 on SharePoint 2010 list

Dan

Hello Daniel Gonski – Assuming you've got two date fields (FirstDate and SecondDate), the following formula in a calculated field will give you the date-difference in days:

**=DATEDIF([FirstDate], [SecondDate],"d")**

instead of math operation, use rather set variable action and within it use fn-DateDiffDays() inline function to calculate the difference.