# DATE\_DIFF

| **Description** | The **`DATE_DIFF`** function computes the time difference in days, weeks, months, quarters, or years between two provided dates (**`End_date`** and **`Start_date`**). This is useful for tracking durations, aging calculations, or date-based analytics. |
| --------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Syntax**      | DATE\_DIFF(**`End_date`**, **`Start_date`**, "day"/"week"/"month"/"quarter"/"year")                                                                                                                                                                        |

1. **`End_date`**: The ending date for the calculation.
2. **`Start_date`**: The starting date for the calculation.
3. **"day"/"week"/"month"/"quarter"/"year"**: Specify the time unit (day, week, month, quarter, or year) for the calculation.

## Example

### Table

| Project   | Start Date | End Date   |
| --------- | ---------- | ---------- |
| Project A | 2023-09-05 | 2023-09-15 |
| Project B | 2023-08-25 | 2023-09-10 |
| Project C | 2023-09-01 | 2023-09-30 |

### Function

```
DATE_DIFF(`End Date`, `Start Date`, "DAY")
```

### Results

| DATEDIFF (integer) |
| ------------------ |
| 10                 |
| 16                 |
| 29                 |
