Views:

Description

Calculate the difference in time between 2 dates for a specified interval.



Inputs:

-From Date

-To Date

-Interval ('y'- Years, 'q'- Quarters, 'm'- Months, 'pm' - Months, 'w'- Weeks, 'd'- Days, 'wd'- Weekdays, 'h'- Hours, 'mi'- Minutes, 's'- Seconds)

Signature

DateDiff('fromdate', 'todate', 'interval')

Example

DateDiff('11/08/2009', '03/20/2011', 'm') Returns 16 (US Format)

DateDiff('03/03/2009', '06/01/2009', 'pm') Returns 4 as there are 4 period months (US Format)

Parameters

NameTypeDescriptionRequired
fromdatexxxxxxxxxxxx
todatexxxxxxxxxxxx
intervalxxxxxxxxxxxx

Notes: