Function: dateDiff()

Return the time difference between two dates in milliseconds.

Note that the function includes any variance for daylight savings changes.

Syntax

dateDiff(date1, date2)

Argument	Type	Description
date1	Date	The original date/time
date2	Date Field	The date to be subtracted from date1

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.