---
title: "*Between"
description: "Calculates the amount of time between two dates"
---

# *Between

> Calculates the amount of time between two dates

**This function is used by Ignition's Expression language.**

## Description

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.

## Syntax

`*Between(date1, date2)`

### Parameters

| Type | Parameter | Description                                                                 |
|------|-----------|-----------------------------------------------------------------------------|
| Date | `date1`   | The first date to compare.                                                  |
| Date | `date2`   | The second date to compare.                                                 |

### Returns

**Integer** - The number of units between the two dates. The units are determined by the specific function used.

## Examples

```python title="Code Snippet"
daysBetween(toDate("2017-04-28 00:00:00"), toDate("2017-03-22 00:00:00")) //This will print -37.
```

```python title="Code Snippet"
weeksBetween({Root Container.Calendar1.date}, {Root Container.Calendar2.date}) //Will grab the number of weeks between two dates of calendar components.
```