dateDiff

Function: dateDiff()

Return the time difference between two dates in milliseconds.

This function includes any variance for daylight savings changes. Use round() to remove these changes.

Syntax

dateDiff(date1,date2)

ArgumentParameter TypesDescription
date1DateThe original date or date-time. For the current date-time use the attribute function now().
date2See Date-Time Functions: dateFieldThe date to be subtracted from date1.

Examples



dateDiff(now(),"20080101.130000")Returns the number of milliseconds since 1pm on 1st January 2008.
round(dateDiff("20200410.000000","20191217.000000")/(1000*60*60*24),0)Returns the number of days between April 10th 2020 and December 17th 2019. The round() call removes any variance for daylight savings shifts.