Versions Compared

Old Version 6

changes.mady.by.user Dina Baksheeva

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 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 the Active checkbox.
  4. Click Save or Save and Exitexit to apply the changes.
Date/Time SpecificEnabled by defaultToday, , Tomorrow, Current hour, , , , , , .Disabled by default. Can be enabled by an admin., , Last quarter, Last half-year, Last year, , , , , business day, Next , half-, Next year.Enabled by defaultToday, , , , , , .Disabled by default. Can be enabled by an admin., , Now, Current hour, , , , , business day, Next , .Enabled by default, , Tomorrow, Current hour,, , ,  ,, .

Disabled by default. Can be enabled by an admin.

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.

Enabled by default, , ,  ,,  ,, , , , , .Disabled by default. Can be enabled by an admin., end , beginning , end , The beginning of last quarter, last quarter, last half-, last , last , last year,  today, today, the current hour, the current hour, , this week, this month, this month, this quarter, this quarter, The beginning of this half-year, this , The beginning of this year, this year, , , The end of the next quarter, The end of the next half-year, The end of the next year.
Condition operatorOptions, enabled by defaultOptions, disabled by default

Column type

DateDate/Time

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 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
at or after

Enabled by default

This day, Yesterday, Tomorrow, Current hour, This week, This month, Last week, Last month, Next week, Next month, 

Disabled by default. Can be enabled by an admin.

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.


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
between

Enabled by default

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.

Disabled by default. Can be enabled by an admin.

2-3-4-5-6-10 days ago, Last business day, The beginning of last quarter, The end of last quarter, The beginning of last half-year,


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
year, Today, Current hour, The beginning of this week,
  • quarter
  • The beginning of last quarter
  • 2-3-4-5-6-10 days ago
  • Last business day
  • Today
  • 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, Next business day,
  • week
  • The beginning of this week
  • 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
  • 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