Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

hiddentrue

Function: dateDiff(

...

)

Return the time difference between two dates in milliseconds.

Function: dateDiff()

...

Note

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

Syntax

dateDiff(date1,date2)

Argument
Type
Parameter TypesDescription
date1DateThe original
date/time
date or date-time. For the current date-time use the attribute function now().
date2See Date
Field
-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.

...

See Also

...


Excerpt
hiddentrue

dateDiff(date1, date2)   Return the time difference between two dates in milliseconds.