Versions Compared

Old Version 12

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,  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 enable them active, 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.
  • Current hour
    • business dayNext business day
  • Last quarter
  • This quarter
  • Last half-year
  • This half-year
  • Next half-year
  • Last year
    • This year, Specific
  • Now
  • Current hour
  • Last business day
  • Next business day
  • 2 days ago
    • 2 days later
  • Next quarter
    • yearLast
  • Next business day
    • 2 days ago
  • Last quarter
  • This quarter
    • Last half-year
  • This half-year
    • Last year
  • This year
    • , Specific
  • Current hour
    • 2 days ago business dayLast half-year year business dayNext , Specific end .
  • Current hour
  • Last business day
  • Today
    • Next business dayThe beginning of this week week month monthThe beginning of last end of last quarterThe quarter end of the next quarterThe half-year half-year year this year
  • The beginning of last half-year
    • The end of last half-year
  • The beginning of last year
    • The end of last yearThe beginning of the current hour the current hour business day business day today today end of the next business day beginning end the day 2-3-4-5-6-10 days later week week month month last last quarter quarter quarter next quarter last half-year last half-year this half-year this half- beginning of last year
  • The end of last year
    • The beginning of this year this yearDate/Time, year Specific
    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
    • 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

    • Current hour


    Date/Time

    only

    before / after

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


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

    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
    • business day
    • 2 days later
    • Next quarter
    • 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
    • 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

    • 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
    • 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

    • 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 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