Options for the Date and Time Fields

The table below lists all the dynamic options for the Date and Date/Time column types in the condition builder. These options are delivered with the platform, but some of them are disabled by default. To enable them, complete the following steps:

Role required: admin.

Navigate to System Settings → Condition Builder → Options.
Find the required option record and open it
Select the Active checkbox.
Click Save or Save and exit to apply the changes.

Condition operator	Options, enabled by default	Options, disabled by default	Column type
on / not on	Today Yesterday Tomorrow This week This month Last week Last month Next week Next month	Last year Last half-year Last quarter 2-3-4-5-6-10 days ago Last business day This quarter This half-year This year Next business day 2-3-4-5-6-10 days later Next quarter Next year	Date, Date/Time
on / not on	Current hour		Date/Time only
before / after	Today Yesterday Tomorrow This week This month Next week Next month	2 days ago Last business day This quarter This half-year This year Next business day 2 days later Next quarter Next year	Date, Date/Time
before / after		Now Current hour	Date/Time only
at or before / at or after	This day Yesterday Tomorrow This week This month Last week Last month Next week Next month	Last year Last half-year Last quarter 2 days ago Last business day This quarter This half-year This year Next business day 2 days later Next quarter Next year	Date, Date/Time
at or before / at or after	Current hour		Date/Time only
between	Yesterday Tomorrow The beginning of last week The end of last week The beginning of last month The end of last month The beginning of the next month The end of the next week The end of the next month	The end of last year The beginning of last year The end of last half-year The beginning of last half-year The end of last quarter The beginning of last quarter 2-3-4-5-6-10 days ago Last business day Today The end of this year Next business day The beginning of this year 2-3-4-5-6-10 days later The end of this half-year The beginning of this half-year The end of this quarter The beginning of this quarter The end of this month The beginning of this month The end of this week The beginning of this week The end of the next year The end of the next half-year The end of the next quarter	Date
between	The beginning of yesterday The end of yesterday The beginning of tomorrow The end of tomorrow The beginning of last week The end of last week The beginning of last month The end of last month The beginning of the next week The end of the next week The beginning of the next month The end of the next month	The end of last year The beginning of last year The end of last half-year The beginning of last half-year The end of last quarter The beginning of last quarter The end of the day 2-3-4-5-6-10 days ago The beginning of the day 2-3-4-5-6-10 days ago The end of last business day The beginning of last business day The end of this year The beginning of this year The end of this half-year The beginning of this half-year The end of this quarter The beginning of this quarter The end of this month The beginning of this month The end of this week The beginning of this week The end of the current hour The beginning of the current hour The end of today The beginning of today The end of the next year The end of the next half-year The end of the next quarter The end of the day 2-3-4-5-6-10 days later The end of the next business day	Date/Time

Page tree

Options for the Date and Time Fields