Versions Compared

Old Version 14

changes.mady.by.user Nikolay Nikitin

Saved on

compared with

New Version Current

changes.mady.by.user Nikolay Nikitin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The table below lists all the dynamic options for the Date, Date/Time, and  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 enable them, complete the following steps:

Tip

Role required: admin.

  1. Navigate to System Settings → Condition Builder → Options.
  2. Find the record of the required option record and option and open it.
  3. Select the Active checkbox.
  4. Click Save or Save and Exitexit to apply the changes.
Condition operatorOptions, enabled by defaultOptions, disabled by default

Column type

on / not on

  • Today
  • Yesterday
  • Tomorrow
  • This week
  • This month
  • Last week
  • Last month
  • Next week
  • Next month


Expand
titleShow options
  • Last business dayNext business dayyear
  • 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 laterLast quarter
  • This quarter
  • Next quarter
  • Last half-year
  • This half-year
  • Last year
  • This year
  • Next year


Date, Date/Time

  • Current hour


Date/Time only

before / after

  • Today
  • Yesterday
  • Tomorrow
  • This week
  • This month
  • Next week
  • Next month


Expand
titleShow options
  • Now2 days ago
  • Last business day
  • This quarter
  • This half-year
  • This year
  • Next business day
  • 2 days ago2 days laterThis quarter
  • Next quarter
  • This half-year
  • This year
  • Next year


Date, Date/Time


  • 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


Expand
titleShow options
  • Last year
  • Last business dayNext business dayhalf-year
  • Last quarter
  • 2 days ago2 days later
  • Last quarterbusiness day
  • This quarter
  • Last This half-year
  • This half- year
  • Next quarter
  • Last year
  • business day
  • 2 days later
  • Next quarterThis year
  • Next year


Date, Date/Time

  • 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


Expand
titleShow options
  • 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
  • Last business day
  • Today
  • Next business day
  • 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 laterThe beginning of this week
  • The end of this weekhalf-year
  • The beginning of this monthhalf-year
  • The end of this monthThe beginning of last quarter
  • The end of last quarterThe beginning of this quarter
  • The end of this quartermonth
  • The end of the next quarterThe beginning of this half-yearmonth
  • The end of this half-yearweek
  • The beginning of this yearweek
  • The end of this year
  • The beginning of last half-year
  • The end of last half-the next year
  • The end of the next half-year
  • The beginning of last yearThe end of last yearThe end of the next yearquarter


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


The beginning of the current hour
Expand
titleShow options
  • The end of the current hourlast year
  • The beginning of last business dayyear
  • The end of last business dayhalf-year
  • The beginning of todaylast half-year
  • The end of todaylast quarter
  • The end of the next business daybeginning of last quarter
  • The beginning end of the day 2-3-4-5-6-10 days ago
  • The end beginning of the day 2-3-4-5-6-10 days ago
  • The end of the day 2-3-4-5-6-10 days laterof last business day
  • The beginning of last business day
  • The end of this year
  • The beginning of this weekyear
  • The end of this weekhalf-year
  • The beginning of this monthhalf-year
  • The end of this monthquarter
  • The beginning of last this quarter
  • The end of last quarterthis month
  • The beginning of this quartermonth
  • The end of this week
  • The beginning of this quarterweek
  • The end of the next quartercurrent hour
  • The beginning of last half-yearthe current hour
  • The end of last half-yeartoday
  • The beginning of this half-yeartoday
  • The end of this half-the next year
  • The end of the next half-yearThe beginning of last year
  • The end of last yearThe beginning of this yearthe next quarter
  • The end of this yearthe day 2-3-4-5-6-10 days later
  • The end of the next yearbusiness day


Date/Time