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 1
DateDiff('11/08/2009', '03/20/2011', 'm') Returns 16 (US Format)
Example 2
DateDiff('03/03/2009', '06/01/2009', 'pm') Returns 4 as there are 4 period months (US Format)
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| fromdate | xxxx | xxxx | xxxx |
| todate | xxxx | xxxx | xxxx |
| interval | xxxx | xxxx | xxxx |