---
schema_version: "1"
id: 63b6ecb5d784bbe07861942bfbdee96cd2e7b049711ac570ae621cde74eb0018
title: daysBetween()
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/reference/bi-saql-functions-date-between.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-date-between.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: ebaab7475828ee3d11114c0ee8d4b1dae7f03714d81cb421023dce7b2dc54bfd
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# daysBetween()

Returns the number of days between two dates. This function is only valid in a `foreach` statement.

## Syntax

`daysBetween(date1, date2)`

_date1_ specifies the start date.

_date2_ specifies the end date.

## Usage

If _date1_ is after _date2_, the number of days returned is a negative number.

You must use `daysBetween()` in a `foreach()` statement. You cannot use this function in `group by`, `order by`, or `filter` statements.

## Example

How many days did it take to close each opportunity? Use `daysBetween()`.

```nolang
q = load "DTC_Opportunity";
q = foreach q generate daysBetween(toDate(CreatedDate_sec_epoch), toDate(CloseDate_sec_epoch) ) as 'Days to Close';
q = order q by 'Days to Close';
```

## Example

How long has each opportunity been open for, in days? Use `daysBetween()` and `now()`.

```nolang
q = load "DTC_Opportunity";
q = filter q by 'Closed' == "false";
q = foreach q generate daysBetween(toDate(CreatedDate_sec_epoch), now() ) as 'Days to Close';
q = order q by 'Days to Close';
```

**See Also**

- [date_diff()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-functions-date-diff.md)
- [Calculate How Long Activities Take](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/concept/bi-saql-examples-daysbetween.md)
- [daysBetween(date1, date2)](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/concept/bi-saql-functions-timezone-days-between.md)