Versions Compared

Old Version 11

changes.mady.by.user Nikolay Nikitin

Saved on

compared with

New Version 12

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 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, complete the following steps:

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

Column type

on / not on
  • Today
  • Yesterday
  • Tomorrow
  • Current hour
  • This week
  • This month
  • Last week
  • Last month
  • Next week
  • Next month


Expand
titleShow options
  • Last business day
  • Next business day
  • 2-3-4-5-6-10 days ago
  • Last business day
  • Last quarter
  • Last half-year
  • Last year
  • This quarter
  • This half-year
  • This year
  • 2-3-4-5-6-10 days later
  • Last quarter
  • This quarterNext business day
  • Next quarter
  • Last half-year
  • This half-year
  • Next half-year
  • Last year
  • This year
  • Next year


Date, Date/Time, Date/Time Specific

before / after
  • Today
  • Yesterday
  • Tomorrow
  • This week
  • This month
  • Next week
  • Next month


Expand
titleShow options
  • Now
  • Current hour2 days ago
  • Last business day
  • Next business day
  • Now
  • 2 days ago
  • 2 days laterCurrent hour
  • This quarter
  • Next quarter
  • This half-year
  • This year
  • 2 days later
  • Next business day
  • Next quarter
  • Next year


Date, Date/Time, Date/Time Specific

at or before
  • This day
  • Yesterday
  • Tomorrow
  • Current hour
  • This week
  • This month
  • Last week
  • Last month
  • Next week
  • Next month


Expand
titleShow options
  • Last business day
  • Next business day
  • 2 days ago
  • Last business day
    • Last
    • 2 days later
    • Last quarter
    • This quarter
    • Last half-year
    Last
    • This half-year
    This
    • Next quarter
    This half-
    • Last year
    • This year
  • 2 days later
    • Next business day
    • Next
    quarterNext
    • year


    Date, 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
    titleShow options
    • 2 days ago
    • Last business day
    • Last quarter
    • Last half-year
    • Last year
    • This quarter
    • This half-year
    • This year
    • 2 days later
    • Next business day
    • Next quarter
    • Next year


    Date, Date/Time, Date/Time Specific

    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 of the next month
    • The end of the next week.


    Expand
    titleShow options
    • Current hour
    • Last business day
    • Today
    • Next business day
    • 2-3-4-5-6-10 days ago
    Last business day
    • 2-3-4-5-6-10 days later
    • The beginning of
    last quarter
    • this week
    • The end of
    last quarter
    • this week
    • The beginning of
    last half-year
    • this month
    • The end of
    last half-year
    • this month
    • The beginning of last
    year
    • quarter
    • The end of last
    year
  • Today
    • Current hour
    • quarter
    • The beginning of this
    week
    • quarter
    • The end of this
    week
  • The beginning of this month
  • The end of this month
    • The beginning of this
    • quarter
    • The end of
    this
    • the next quarter
    • The beginning of this half-year
    • The end of this half-year
    • The beginning of this year
    • The end of this year
  • 2-3-4-5-6-10 days later
  • Next business day
    • The end of the next quarter
    • The beginning of last half-year
    • The end of last half-year
    • The end of the next half-year
    • The beginning of last year
    • The end of last 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
    titleShow options
    • The beginning of the current hour
    • The end of the current hour
    • The beginning of last business day
    • The end of last business day
    • The beginning of today
    • The end of today
    • The end of the next business day
    • The beginning of the day 2-3-4-5-6-10 days ago
    • The end of the day 2-3-4-5-6-10 days ago
    • The beginning of last business day The end of last business daythe day 2-3-4-5-6-10 days later
    • The beginning of last quarterthis week
    • The end of last quarterthis week
    • The beginning of last half-yearthis month
    • The end of last half-yearthis month
    • The beginning of last yearquarter
    • The end of last year
    • The beginning of today
    • The end of todayquarter
    • The beginning of the current hour
    • The end of the current hour
    • The beginning of this weekthis quarter
    • The end of this week
    • The beginning of this month
    • The end of this month
    • The beginning of this quarter
    • The end of this the next quarter
    • The beginning of this last half-year
    • The end of this last half-year
    • The beginning of this half-year
    • The end of this half-year
    • The end of the day 2-3-4-5-6-10 days laternext half-year
    • The beginning of last year
    • The end of the next business daylast year
    • The end of the next quarterbeginning of this year
    • The end of the next half-this year
    • The end of the next year


    Date/Time, Date/Time Specific