Skip to main content
Version: 1.21.3

Options for 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:

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

on / not on​

Options, enabled by defaultOptions, disabled by default
Date and Date/Time
  • 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/Time onlyCurrent hour-

before / after​

Options, enabled by defaultOptions, disabled by default
Date and Date/Time
  • 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/Time only-
  • Now
  • Current hour

at or before / at or after​

Options, enabled by defaultOptions, disabled by default
Date and Date/Time
  • 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/Time onlyCurrent hour-

between​

Options, enabled by defaultOptions, disabled by default
Date
  • 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/Time
  • 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