Views:

Description

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



Inputs:

-From Date

-To Date

-Interval ('y'- Years, 'm'- Months, 'q'- Days, 'h'- Hours, 'mi'- Minutes, 's'- Seconds)

Signature

DateDiffElapsed('fromdate', 'todate', 'interval')

Example



DateDiffElapsed('11/08/2009', '03/20/2011', 'm') Returns 4 (US Format)

Parameters

NameTypeDescriptionRequired
fromdatexxxxxxxxxxxx
todatexxxxxxxxxxxx
intervalxxxxxxxxxxxx

Notes: