Between Date Function Calls

Introduction

Between date function calls calculate the differences between two dates.

For a deep-dive look into working with DateTime functions, check out this video:

millisecondsBetween

The millisecondsBetween function calculates the difference between the input values in milliseconds.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

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

The output is:

2000

secondsBetween

The secondsBetween function calculates the difference between the input values in seconds.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

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

The output is:

62

minutesBetween

The minutesBetween function calculates the difference between the input values in minutes.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

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

The output is:

1

hoursBetween

The hoursBetween function calculates the difference between the input values in hours.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

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

The output is:

2.5

daysBetween

The daysBetween function calculates the difference between the input values in days.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

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

The output is:

43

weeksBetween

The weeksBetween function calculates the difference between the input values in weeks.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

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

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

1.1428571428571428

calendarMonthsBetween

The calendarMonthsBetween function calculates the difference between the input values in months. Time will be ignored. The dates are assumed to be in the end-user's local time zone.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

calendarMonthsBetween(dateTime(2007, 1, 1, 10, 1, 1), dateTime(2007, 8, 1, 1, 1, 1))

The output results in the amount of months between the two dates:

7

calendarYearsBetween

The calendarYearsBetween function calculates the difference between the input values in years. Time will be ignored. The dates are assumed to be in the end-user's local time zone.

Input Parameters

The input parameters are described in the table below:

Output

The output is described in the table below:

Example

If you use the following input:

calendarYearsBetween(dateTime(2007, 1, 1, 10, 1, 1), dateTime(2017, 1, 1, 1, 1, 1))

The output results in the amount of years between the two dates:

10