# daysBetween(date1, date2)

Returns the number of days between two dates as an integer.

For example, display the number of days to close a deal. `OpenDate` and `CloseDate` fields can be `DateTime` or `DateOnly`.

```nolang
q = foreach q generate daysBetween('OpenDate','CloseDate') as "Days to Close";
```

**See Also**

- [daysBetween()](/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-date-between.md)