Filter by Date Presets
Share via
Copy Link
When you configure a filter in the query editor, in a chart, or in a custom record field, you can filter any Date or Date and Time fields by a date preset.
Date presets allow you to dynamically filter your data based on a selected time frame.
For example, if you select the date preset Today, the filter value will update each day to reflect the correct date. When you use a date preset, all date and time values are returned in Greenwich Mean Time (GMT).
The table below lists the available date presets for Date and Date and Time fields. To ensure you're selecting the correct date preset, review the underlying expression associated with each preset.
| Field Type | Operator | Date Preset | Underlying Expression | Example (If today is September 24, 2021) |
|---|
Field Type | Operator | Date Preset | Underlying Expression | Example (If today is September 24, 2021) |
|---|---|---|---|---|
| Date | =, <>, >, >=, <, <= | Today |
|
9/24/2021 |
| Date | =, <>, >, >=, <, <= | Yesterday |
|
9/23/2021 |
| Date | =, <>, >, >=, <, <= | Day Before Yesterday |
|
9/22/2021 |
| Date | =, <>, >, >=, <, <= | Today Last Week |
|
9/17/2021 |
| Date | =, <>, >, >=, <, <= | Today Last Month |
|
8/24/2021 |
| Date | =, <>, >, >=, <, <= | Today Last Year |
|
9/24/2020 |
| Date | Date Range | Week-to-Date (From Monday of the Current Week) |
|
{9/20/2021, 9/24/2021} |
| Date | Date Range | Week-to-Date (From Sunday of the Current Week) |
|
{9/19/2021, 9/24/2021} |
| Date | Date Range | Previous Week-to-Date (From Monday to Today of the Previous Week) |
|
{9/13/2021, 9/17/2021} |
| Date | Date Range | Previous Week-to-Date (From Sunday to Today of the Previous Week) |
|
{9/12/2021, 9/17/2021} |
| Date | Date Range | Month-to-Date |
|
{9/1/2021, 9/24/2021} |
| Date | Date Range | Previous Month-to-Date (From Beginning of Last Month to Today Last Month) |
|
{8/1/2021, 8/24/2021} |
| Date | Date Range | Month-to-Date Last Year (From Beginning of This Month Last Year to Today Last Year) |
|
{9/1/2020, 9/24/2020} |
| Date | Date Range | Year-to-Date |
|
{1/1/2021, 9/24/2021} |
| Date | Date Range | Previous Year-to-Date (From Beginning of Last Year to Today Last Year) |
|
{1/1/2020, 9/24/2020} |
| Date | Date Range | Beginning of Last Month to Today |
|
{8/1/2021, 9/24/2021} |
| Date | Date Range | Trailing 3 Months |
|
{6/1/2021, 8/31/2021} |
| Date | Date Range | Trailing 6 Months |
|
{3/1/2021, 8/31/2021} |
| Date | Date Range | Trailing 9 Months |
|
{12/1/2020, 8/31/2021} |
| Date | Date Range | Trailing 12 Months |
|
{9/1/2020, 8/31/2021} |
| Date | Date Range | Trailing 18 Months |
|
{3/1/2020, 8/31/2021} |
| Date and Time | =, <>, >, >=, <, <= | Today: Current Time |
|
9/24/2021 2:30 PM GMT+00:00 |
| Date and Time | =, <>, >, >=, <, <= | Today: Beginning of the Day |
|
9/24/2021 12:00 AM GMT+00:00 |
| Date and Time | =, <>, >, >=, <, <= | Yesterday: Current Time That Day |
|
9/23/2021 2:30 PM GMT+00:00 |
| Date and Time | =, <>, >, >=, <, <= | Yesterday: Beginning of the Day |
|
9/23/2021 12:00 AM GMT+00:00 |
| Date and Time | =, <>, >, >=, <, <= | Day Before Yesterday: Current Time That Day |
|
9/22/2021 2:30 PM GMT+00:00 |
| Date and Time | =, <>, >, >=, <, <= | Day Before Yesterday: Beginning of the Day |
|
9/22/2021 12:00 AM GMT+00:00 |
| Date and Time | Date Range | Today: From Midnight to Current Time |
|
{9/24/2021 12:00 AM GMT+00:00, 9/24/2021 2:30 PM GMT+00:00} |
| Date and Time | Date Range | Yesterday: From Midnight to Current Time That Day |
|
{9/23/2021 12:00 AM GMT+00:00, 9/23/2021 2:30 PM GMT+00:00} |
| Date and Time | Date Range | Day Before Yesterday: From Midnight to Current Time That Day |
|
{9/22/2021 12:00 AM GMT+00:00, 9/22/2021 2:30 PM GMT+00:00} |
| Date and Time | Date Range | Week-to-Date (From Monday of the Current Week) |
|
{9/20/2021 12:00 AM GMT+00:00, 9/24/2021 2:30 PM GMT+00:00} |
| Date and Time | Date Range | Week-to-Date (From Sunday of the Current Week) |
|
{9/19/2021 12:00 AM GMT+00:00, 9/24/2021 2:30 PM GMT+00:00} |
| Date and Time | Date Range | Previous Week-to-Date (From Monday to Today of the Previous Week) |
|
{9/13/2021 12:00 AM GMT+00:00, 9/17/2021 2:30 PM GMT+00:00} |
| Date and Time | Date Range | Previous Week-to-Date (From Sunday to Today of the Previous Week) |
|
{9/12/2021 12:00 AM GMT+00:00, 9/17/2021 2:30 PM GMT+00:00} |
| Date and Time | Date Range | Month-to-Date |
|
{9/1/2021 12:00 AM GMT+00:00, 9/24/2021 2:30 PM GMT+00:00} |
| Date and Time | Date Range | Previous Month-to-Date (From Beginning of Last Month to Today Last Month) |
|
{8/1/2021 12:00 AM GMT+00:00, 8/24/2021 2:30 PM GMT+00:00} |
| Date and Time | Date Range | Year-to-Date |
|
{1/1/2021 12:00 AM GMT+00:00, 9/24/2021 2:30 PM GMT+00:00} |
| Date and Time | Date Range | Month-to-Date Last Year (From Beginning of This Month Last Year to Today Last Year) |
|
{9/1/2020 12:00 AM GMT+00:00, 9/24/2020 2:30 PM GMT+00:00} |
| Date and Time | Date Range | Previous Year-to-Date (From Beginning of Last Year to Today Last Year) |
|
{1/1/2020 12:00 AM GMT+00:00, 9/24/2020 2:30 PM GMT+00:00} |
| Date and Time | Date Range | Beginning of Last Month to Today |
|
{8/1/2021 12:00 AM GMT+00:00, 9/24/2021 2:30 PM GMT+00:00} |
| Date and Time | Date Range | Trailing 3 Months |
|
{6/1/2021 12:00 AM GMT+00:00, 9/1/2021 12:00 AM GMT+00:00} |
| Date and Time | Date Range | Trailing 6 Months |
|
{3/1/2021 12:00 AM GMT+00:00, 9/1/2021 12:00 AM GMT+00:00} |
| Date and Time | Date Range | Trailing 9 Months |
|
{12/1/2020 12:00 AM GMT+00:00, 9/1/2021 12:00 AM GMT+00:00} |
| Date and Time | Date Range | Trailing 12 Months |
|
{9/1/2020 12:00 AM GMT+00:00, 9/1/2021 12:00 AM GMT+00:00} |
| Date and Time | Date Range | Trailing 18 Months |
|
{3/1/2020 12:00 AM GMT+00:00, 9/1/2021 12:00 AM GMT+00:00} |