The table below lists all the dynamic options for the Date, and Date/Time, and Date/Time Specific column types in the condition builder. These options are delivered with the platform, but some of them are disabled by default. To make them active or deactivate the options you do not needenable them, complete the following steps:
- Navigate to System Settings → Condition Builder → Options.
- Find the record of the required option record and option and open it.
- Select or clear the Active checkbox.
- Click Save or Save and Exitexit to apply the changes.
Condition operator | Options, enabled by default | Options, disabled by default | Column type |
---|
on / not on
| |
Current hour- This week
- This month
- Last week
- Last month
- Next week
- Next month
|
Expand |
---|
| - Last year
- Last half-year
- Last quarter
- 2-3-4-5-6-10 days ago
- Last business day
|
|
Last quarterLast half-year |
Last year- This quarter
- This half-year
- This year
- Next business day
- 2-3-4-5-6-10 days later
- Next
|
|
business dayNext |
Next half-year | Date, Date/Time |
, |
| | Date/Time |
Specificonly |
before / after
| - Today
- Yesterday
- Tomorrow
- This week
- This month
- Next week
- Next month
|
Expand |
---|
| - 2 days ago
- Last business day
|
|
NowCurrent hour- This quarter
- This half-year
- This year
- Next business day
- 2 days later
- Next
|
|
business dayNext | Date, Date/Time |
, |
| | Date/Time |
Specificonly |
at or before / at or after
| - This day
- Yesterday
- Tomorrow
|
Current hour- This week
- This month
- Last week
- Last month
- Next week
- Next month
| |
2 days ago |
Last business day |
quarter |
yearThis |
This half-yearThis year |
laterNext business dayNext quarterNext yearDate, Date/Time, Date/Time Specific | at or after | - This day
- Yesterday
- Tomorrow
- Current hour
- This week
- This month
- Last week
- Last month
- Next week
- Next month
| Expand |
2 days |
Last quarterLast half-yearLast year- This quarter
- This half-year
- This year
- Next business day
- 2 days later
|
|
Next business day | Date, Date/Time |
, |
| | Date/Time |
Specificonly |
between
| - Yesterday
- Tomorrow
- The beginning of last week
- The end of last week
- The beginning of last month
- The end of last month
- The
|
end - beginning of the next month
- The end of the next week
|
.- The end of the next month
| |
2-3-4-5-6-10 days agoLast business day |
The beginning of last quarter |
quarter- year
- The beginning of last
|
|
half-- year
- The end of last half-year
- The beginning of last half-year
- The end of last
|
|
yearTodayCurrent hour- quarter
- The beginning of last quarter
- 2-3-4-5-6-10 days ago
- Last business day
- Today
|
|
The beginning of this week |
week- year
- Next business day
- The beginning of this
|
|
month- year
- 2-3-4-5-6-10 days later
- The end of this
|
|
month- half-year
- The beginning of this
|
|
quarter- half-year
- The end of this quarter
- The beginning of this
|
|
half-year |
half-year- month
- The beginning of this
|
|
year |
year2-3-4-5-6-10 days later- week
- The beginning of this week
|
|
Next business day |
quarter- year
- The end of the next half-year
- The end of the next
|
|
year | Date |
- 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
|
Expand |
---|
| - 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
|
|
|
end - beginning of the day 2-3-4-5-6-10 days ago
- The
|
|
beginning - end of last business day
- The
|
|
end - beginning of last business day
- The
|
|
beginning of last quarter The |
last quarter- this year
- The beginning of
|
|
last half- |
last - this half-year
- The beginning of
|
|
last |
last year- this quarter
- The beginning of
|
|
today |
today- this month
- The beginning of
|
|
the current hour |
the current hour- this week
- The beginning of this week
- The end of
|
|
this week- the current hour
- The beginning of
|
|
this month- the current hour
- The end of
|
|
this month |
this quarter |
this quarterThe beginning of this half- |
this |
year The beginning of this |
this year- the next quarter
- The end of the day
|
|
- 2-3-4-5-6-10 days later
- The end of the next business day
|
|
The end of the next quarter The end of the next half-year The end of the next yearDate/Time, | Date/Time |
Specific |