Versions Compared

Old Version 7

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 them active or deactivate the options you do not needenable 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 or clear 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
  • Current hour
    • 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
  • Last quarter
    • Last 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
    • quarter
    Next half-year
    • Next year


    Date, Date/Time

    ,

    • Current hour


    Date/Time

    Specific

    only

    before / after

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


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


    Date, Date/Time

    ,


    • Now
    • Current hour

    Date/Time

    Specific

    only

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


    • Expand
    titleShow options
    • Last
    Last half-
    • year
    • Last
    year
  • This quarter
    • This

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


    Date, Date/Time

    ,

    • Current hour


    Date/Time

    Specific

    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
    end
    • beginning of the next month
    • The end of the next week
    .
  • 2-3-4-5-6-10 days ago
  • Last business day
    • The end of the next month


    Expand
    titleShow options
    The beginning of last quarter
    • The end of last
    quarter
    • year
    • The beginning of last
    half-
    • year
    • The end of last half-year
    • The beginning of last half-year
    • The end of last
    year
  • Today
  • Current hour
    • quarter
    • The beginning of last quarter
    • 2-3-4-5-6-10 days ago
    • Last business day
    • Today
    The beginning of this week
    • The end of this
    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
    • quarter
    • The end of this
    half-year
    • month
    • The beginning of this
    year
    • month
    • The end of this
    year
  • 2-3-4-5-6-10 days later
    • week
    • The beginning of this week
    Next business day
    • The end of the next
    quarter
    • year
    • The end of the next half-year
    • The end of the next
    year
    • 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
    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
    • end of
    last quarter
    • this year
    • The beginning of
    last half-
    • this year
    • The end of
    last
    • this half-year
    • The beginning of
    last
    • this half-year
    • The end of
    last year
    • this quarter
    • The beginning of
    today
    • this quarter
    • The end of
    today
    • this month
    • The beginning of
    the current hour
    • this month
    • The end of
    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
    • today
    • The beginning of
    this quarter
    • today
    • The end of
    this quarterThe beginning of this half-
    • the next year
    • The end of
    this
    • the next half-
    year The beginning of this
    • year
    • The end of
    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 year
    • Date/Time,


    Date/Time

    Specific