Between Date Function Calls

Last update: Edit

1 Introduction

Functions for calculating the differences between two dates.

2 millisecondsBetween

  • First date Type: DateTime
  • Second date Type: DateTime

2.1 Output

Returns the difference between the two dates, as a Decimal, measured in milliseconds.

For example:

millisecondsBetween(dateTime(2007, 1, 1, 1, 1, 1), dateTime(2007,1,1,1,1,3))

results in

2000

3 secondsBetween

  • First date Type: DateTime
  • Second date Type: DateTime

3.1 Output

Returns the difference between the two dates, as a Decimal, measured in seconds.

For example:

secondsBetween(dateTime(2007, 1, 1, 1, 1, 1), dateTime(2007,1,1,1,2,3))

results in

62

4 minutesBetween

  • First date Type: DateTime
  • Second date Type: DateTime

4.1 Output

Returns the difference between the two dates, as a Decimal, measured in minutes.

For example:

minutesBetween(dateTime(2007, 1, 1, 1, 2, 1), dateTime(2007,1,1,1,1,1))

results in

1

5 hoursBetween

  • First date Type: DateTime
  • Second date Type: DateTime

5.1 Output

Returns the difference between the two dates, as a Decimal, measured in hours.

For example:

hoursBetween(dateTime(2007, 1, 1, 3, 31, 1), dateTime(2007,1,1,1,1,1))

results in

2.5

6 daysBetween

  • First date Type: DateTime
  • Second date Type: DateTime

6.1 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:

daysBetween(dateTime(2007, 2, 13, 1, 1, 1), dateTime(2007,1,1,1,1,1))

results in

43

7 weeksBetween

  • First date Type: DateTime
  • Second date Type: DateTime

7.1 Output

Returns the difference between the two dates, as a Decimal, measured in weeks.

For example:

weeksBetween(dateTime(2007, 1, 9, 1, 1, 1), dateTime(2007,1,1,1,1,1))

results in 8 days divided by 7 days in a week:

1.1428571428571428