DURATIONDAYS

(date Fromdate To)
Gets the days component of the from - to period.
Example: DURATIONDAYS(DATE(2016,1,20,1,2,3,400), DATE(2017,3,23,5,8,11,500)) is the days
component of the period (428).
From: Required. The start date of the period.

Example

Calculates the number of days between "Due Date" and "Shipment Date":
durationdays(&ShipmentDate,&DueDate)
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.