/
dateDiff
PhixFlow Help
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)
Argument | Parameter Types | Description |
---|---|---|
date1 | Date | The original date or date-time. For the current date-time use the attribute function now(). |
date2 | See Date-Time Functions: dateField | The 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. |
Related content
15 Creating and using macros
15 Creating and using macros
Read with this
14 Attribute scripting
14 Attribute scripting
Read with this
Macro
Macro
Read with this
Please let us know if we could improve this page feedback@phixflow.com