Free cookie consent management tool by TermsFeed Filter by Date Presets
Filter by Date Presets

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)
Date =, <>, >, >=, <, <= Today

today()

9/24/2021
Date =, <>, >, >=, <, <= Yesterday

today()-1

9/23/2021
Date =, <>, >, >=, <, <= Day Before Yesterday

today() -2

9/22/2021
Date =, <>, >, >=, <, <= Today Last Week

today() - 7

9/17/2021
Date =, <>, >, >=, <, <= Today Last Month

date(year(eomonth(today(), -1)), month(eomonth(today(), -1)), day(today()))

8/24/2021
Date =, <>, >, >=, <, <= Today Last Year

edate(today(), -12)

9/24/2020
Date Date Range Week-to-Date (From Monday of the Current Week)

{today() - weekday(today(), 2) + 1, today()}

{9/20/2021, 9/24/2021}
Date Date Range Week-to-Date (From Sunday of the Current Week)

{today() - weekday(today(), 1) + 1, today()}

{9/19/2021, 9/24/2021}
Date Date Range Previous Week-to-Date (From Monday to Today of the Previous Week)

{todate(today() - 7 - weekday(today(), 2) + 1), today() - 7 }

{9/13/2021, 9/17/2021}
Date Date Range Previous Week-to-Date (From Sunday to Today of the Previous Week)

{todate(today() - 7 - weekday(today(), 1) + 1), today() - 7 }

{9/12/2021, 9/17/2021}
Date Date Range Month-to-Date

{eomonth(today(),-1) + 1, today()}

{9/1/2021, 9/24/2021}
Date Date Range Previous Month-to-Date (From Beginning of Last Month to Today Last Month)

{eomonth(date(year(eomonth(today(), - 1)), month(eomonth(today(), - 1)), day(today())), - 1) + 1, date(year(eomonth(today(), - 1)), month(eomonth(today(), - 1)), day(today()))}

{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)

{eomonth(today(),-13) + 1, edate(today(), -12)}

{9/1/2020, 9/24/2020}
Date Date Range Year-to-Date

{date(year(today()), 1, 1), today()}

{1/1/2021, 9/24/2021}
Date Date Range Previous Year-to-Date (From Beginning of Last Year to Today Last Year)

{date(year(today())-1, 1, 1), edate(today(), -12)}

{1/1/2020, 9/24/2020}
Date Date Range Beginning of Last Month to Today

{eomonth(today(),-2) + 1, today()}

{8/1/2021, 9/24/2021}
Date Date Range Trailing 3 Months

{eomonth(today(),-4) + 1, eomonth(today(),-1)}

{6/1/2021, 8/31/2021}
Date Date Range Trailing 6 Months

{eomonth(today(),-7) + 1, eomonth(today(),-1)}

{3/1/2021, 8/31/2021}
Date Date Range Trailing 9 Months

{eomonth(today(),-10) + 1, eomonth(today(),-1)}

{12/1/2020, 8/31/2021}
Date Date Range Trailing 12 Months

{eomonth(today(),-13) + 1, eomonth(today(),-1)}

{9/1/2020, 8/31/2021}
Date Date Range Trailing 18 Months

{eomonth(today(),-19) + 1, eomonth(today(),-1)}

{3/1/2020, 8/31/2021}
Date and Time =, <>, >, >=, <, <= Today: Current Time

now()

9/24/2021 2:30 PM GMT+00:00
Date and Time =, <>, >, >=, <, <= Today: Beginning of the Day

todatetime(today())

9/24/2021 12:00 AM GMT+00:00
Date and Time =, <>, >, >=, <, <= Yesterday: Current Time That Day

now() - 1

9/23/2021 2:30 PM GMT+00:00
Date and Time =, <>, >, >=, <, <= Yesterday: Beginning of the Day

todatetime(today()-1)

9/23/2021 12:00 AM GMT+00:00
Date and Time =, <>, >, >=, <, <= Day Before Yesterday: Current Time That Day

now() -2

9/22/2021 2:30 PM GMT+00:00
Date and Time =, <>, >, >=, <, <= Day Before Yesterday: Beginning of the Day

todatetime(today()-2)

9/22/2021 12:00 AM GMT+00:00
Date and Time Date Range Today: From Midnight to Current Time

{todatetime(today()), now()}

{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

{todatetime(today()-1), now()-1}

{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

{todatetime(today()-2), now()-2}

{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)

{todatetime(today() - weekday(today(), 2) + 1), now()}

{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)

{todatetime(today() - weekday(today(), 1) + 1), now()}

{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)

{todatetime(today() - 7 - weekday(today(), 2) + 1), now()-7}

{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)

{todatetime(today() - 7 - weekday(today(), 1) + 1), now()-7}

{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

{todatetime(eomonth(today(),-1) + 1), now()}

{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)

{todatetime(eomonth(date(year(eomonth(today(), - 1)), month(eomonth(today(), - 1)), day(today())), - 1) + 1), datetime(year(eomonth(today(), - 1)), month(eomonth(today(), - 1)), day(today()), hour(now()), minute(now()), second(now()), milli(now()))}

{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

{datetime(year(today()), 1, 1), now()}

{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)

{todatetime(eomonth(today(),-13) + 1), if(isleapyear(year(now())), now() - 366, now() - 365)}

{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)

{datetime(year(today()) - 1, 1, 1), edate(today(), - 12) + (now() - today())}

{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

{todatetime(eomonth(today(),-2) + 1), now()}

{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

todatetime({eomonth(today(),-4) + 1, eomonth(today(),-1) + 1})

{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

todatetime({eomonth(today(),-7) + 1, eomonth(today(),-1) + 1})

{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

todatetime({eomonth(today(),-10) + 1, eomonth(today(),-1) + 1})

{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

todatetime({eomonth(today(),-13) + 1, eomonth(today(),-1) + 1})

{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

todatetime({eomonth(today(),-19) + 1, eomonth(today(),-1) + 1})

{3/1/2020 12:00 AM GMT+00:00, 9/1/2021 12:00 AM GMT+00:00}
Open in Github Built: Thu, Jun 13, 2024 (05:03:21 PM)

Filter by Date Presets

FEEDBACK