---
schema_version: "1"
id: c021dbd507edebe6232aafb4b95c8a75ee5d71449cd3422ae1a6c7478e37451e
title: daysBetween(date1, date2)
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/concept/bi-saql-functions-timezone-days-between.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-timezone-days-between.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 57056c7dccfd346df8dbdf361b900e8d0d89f6ced4544eda2346990da031356f
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# 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()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/reference/bi-saql-functions-date-between.md)