You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 16 Next »

The table below lists all the dynamic options for the Date and Date/Time 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:

Role required: admin.

  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
  • This week
  • This month
  • Last week
  • Last month
  • Next week
  • Next month
  • Last business day
  • Next business day
  • 2-3-4-5-6-10 days ago
  • 2-3-4-5-6-10 days later
  • Last 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
  • Last business day
  • Next business day
  • 2 days ago
  • 2 days later
  • This 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
  • Last business day
  • Next business day
  • 2 days ago
  • 2 days later
  • Last quarter
  • This quarter
  • Last half-year
  • This half-year
  • Next quarter
  • Last year
  • This 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
  • Last business day
  • Today
  • Next business day
  • 2-3-4-5-6-10 days ago
  • 2-3-4-5-6-10 days later
  • The beginning of this week
  • The end of this week
  • The beginning of this month
  • The end of this month
  • The beginning of last quarter
  • The end of last quarter
  • The beginning of this quarter
  • The end of this quarter
  • The end of 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
  • 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
  • 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 end of the day 2-3-4-5-6-10 days later
  • The beginning of this week
  • The end of this week
  • The beginning of this month
  • The end of this month
  • The beginning of last quarter
  • The end of last quarter
  • The beginning of this quarter
  • The end of this quarter
  • The end of the next quarter
  • The beginning of last half-year
  • The end of last half-year
  • The beginning of this half-year
  • The end of this half-year
  • The end of the next half-year
  • The beginning of last year
  • The end of last year
  • The beginning of this year
  • The end of this year
  • The end of the next year

Date/Time


  • No labels

© 2019-2024, SimpleOne

https://simpleone.ru