Mendix 7 is no longer supported unless you have Extended Support (for details, please contact Mendix Support). Mendix 7 documentation will remain available for customers with Extended Support until July, 2024.
Between Date Function Calls
Functions for calculating the differences between two dates.
millisecondsBetween
- First date Type: DateTime
- Second date Type: DateTime
Output
Returns the difference between the two dates, as a Decimal, measured in milliseconds.
For example:
|
|
results in
|
|
secondsBetween
- First date Type: DateTime
- Second date Type: DateTime
Output
Returns the difference between the two dates, as a Decimal, measured in seconds.
For example:
|
|
results in
|
|
minutesBetween
- First date Type: DateTime
- Second date Type: DateTime
Output
Returns the difference between the two dates, as a Decimal, measured in minutes.
For example:
|
|
results in
|
|
hoursBetween
- First date Type: DateTime
- Second date Type: DateTime
Output
Returns the difference between the two dates, as a Decimal, measured in hours.
For example:
|
|
results in
|
|
daysBetween
- First date Type: DateTime
- Second date Type: DateTime
Output
Returns the difference between the two dates as a positive Decimal measured in days. Time is taken into consideration, so comparing date-x 0:00
with date-x 06:00
will result in 0.25000000
.
For example:
|
|
results in
|
|
weeksBetween
- First date Type: DateTime
- Second date Type: DateTime
Output
Returns the difference between the two dates, as a Decimal, measured in weeks.
For example:
|
|
results in 8 days divided by 7 days in a week:
|
|