*Between
This function is a set of functions that include:
|
Function |
Description |
|
millisBetween |
Calculates the number of whole milliseconds between two dates. |
|
secondsBetween |
Calculates the number of whole seconds between two dates. |
|
minutesBetween |
Calculates the number of whole minutes between two dates. |
|
hoursBetween |
Calculates the number of whole hours between two dates. |
|
daysBetween |
Calculates the number of whole days between two dates. Daylight savings changes are taken into account. |
|
weeksBetween |
Calculates the number of whole weeks between two dates. |
|
monthsBetween |
Calculates the number of whole months between two dates. Daylight savings changes are taken into account. |
|
yearsBetween |
Calculates the number of whole years between two dates. Daylight savings changes are taken into account. |
Order does matter for the two dates passed in that we are calculating how much time has passed from date 1 to date 2. So, if date 2 is further in time than date 1, then a positive amount of time has passed. If date 2 is backwards in time from date 1, then a negative amount of time has passed.
*between ( date_1, date_2 )
daysBetween(toDate("2017-04-28 00:00:00"), toDate("2017-03-22 00:00:00")) //This will print -37weeksBetween({Root Container.Calendar1.date}, {Root Container.Calendar2.date}) //Will grab the number of weeks between two dates of calendar components.