cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Math operation Returning Total # of Seconds between two dates rather than Days?

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

0 Kudos
Reply
5 Replies
Automation Master
Automation Master

Re: Math operation Returning Total # of Seconds between two dates rather than Days?

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

Reply
Automation Master
Automation Master

Re: Math operation Returning Total # of Seconds between two dates rather than Days?

Hi

Please see this similar thread:

https://community.nintex.com/thread/11295

Thanks

Cassy

0 Kudos
Reply
Automation Master
Automation Master

Re: Math operation Returning Total # of Seconds between two dates rather than Days?

did you resolve this Daniel Gonski​?

0 Kudos
Reply
Automation Master
Automation Master

Re: Math operation Returning Total # of Seconds between two dates rather than Days?

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")

0 Kudos
Reply
pgbcld
Nintex Newbie

Re: Math operation Returning Total # of Seconds between two dates rather than Days?

There are 86,400 seconds in a day so you could also convert the number of seconds to day by dividing: numberOfSeconds/86,400. 

However it looks like there are some cleaner options already mentioned.

Reply