dateDiff

Function: dateDiff()

Return the time difference between two dates in milliseconds.

Syntax

dateDiff(date1, date2)

ArgumentTypeDescription
date1DateThe original date/time
date2Date FieldThe date to be subtracted from date1

Examples

dateDiff(now(),"20080101.130000")

Returns the number of milliseconds since 1pm on 1st January 2008.

See Also