# DateDiff

The **DateDiff** function calculates the time difference between two dates.

### Syntax

`DateDiff(unit, start, end)`

The function has the following arguments:

|          |                                                                                                                                                                                                                                                                                   |
| -------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **unit** | (required) The unit to measure the difference. Can be one of “year”, "quarter", “month”, “week”, “day”, “hour”, “minute”, “second”, “millisecond”.                                                                                                                                |
| start    | (required) The starting date. Note that the value must be a date. If the column is not in the appropriate format, use the [date](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/type-functions/date "mention") function on the argument. |
| **end**  | (required) The ending date. Note that the value must be a date. If the column is not in the appropriate format, use the [date](https://support.meetuma.ai/uma-knowledgebase/data-and-reporting/analytics-pro/functions/type-functions/date "mention") function on the argument.   |

### Examples

```
DateDiff(“day”, [Invoice Date], Today())
```

Returns the number of days between the date in the *Invoice Date* column and the current UTC date.

```
DateDiff("year", [Invoice Date], Date("2018-01-01")) = 8
```

Returns the number of years between the date in the *Invoice Date* column and January 1, 2018.

```
DateDiff("hour", [Ticket Date], Now()) = 103
```

Returns the number of hours between the date and time in the *Ticket Date* column and the current UTC date and time.