---
schema_version: "1"
id: 8ecc40825f1adc55d563eaf81b77fc3b7346f7d02e93a8be96d9635f4c420c53
title: date_between?
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_function_ref_date_between.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_date_between.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 57d92a574ce9ecc075717c67fd215287a0371f28a2a3e6086332ba51fefa3c0f
description: Checks whether a date falls within an upper and lower date range in Salesforce Spiff. When used in a calculated field, this function returns true or false.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# date\_between?

Checks whether a date falls within an upper and lower date range in Salesforce Spiff. When used in a calculated field, this function returns `true` or `false`.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

## Syntax

```
date_between?(date, start_date, end_date)
```

## Arguments

  
| Argument | Required? | Description |
| --- | --- | --- |
| date | Required | The date to check. This argument supports any date functions. |
| start\_date | Required | The lower bound of the date range to check. This argument supports any date functions. |
| end\_date | Required | The upper bound of the date range to check. This argument supports any date functions. |

## Considerations

The `date_between?()` function is a default function when you turn off Syntax Editor when creating a data filter in Designer. For example, a filter where CloseDate is within the Current Period is the same as this function.

```
date_between?(CloseDate, statement_period.start_date, end_of_period(statement_period.start_date))
```

![An example of the date\_between function in a data filter with Syntax Editor turned on and off](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_function_ref_date_between.png)

## Example

Check whether a rep's ramp start date is January 1 falls within a statement period's start and end date.

```
=date_between?(date("2024-01-01"), statement_period.start_date, statement_period.end_date)
```