Understanding use of Date datatype in Rule Builder

The use of the Date datatype in the Rule Builder includes these functions.

  • When you select a Date datatype widget in an expression, only corresponding operators and reference widgets are displayed. For example:
    • If you write an expression on Schedule Ship Date, only relevant operators such as Equal, Not Equal, Less Than, Less Than or Equal, Greater Than, Greater Than or Equal, and Between are displayed.
    • The reference widget only has relevant datatype widgets such as Requested Ship Date, Delivery Date, Promised Delivery Date, etc.
  • You can use special values such as Today, Now, and Hour with Date datatype widgets.
    • Today: Today’s date with time as 12:00 am
    • Now: Today’s date with time as current time
    • Hour: Today’s date with time as current hour
  • Valid expressions with Date datatype include:
    • Use Today with a +/- operator with a constant value of days days/hours/minutes.
    • Use Now with a +/- operator with a constant value of days/hours/minutes
    • Use Hour with a +/- operator with a constant value of days/hours/minutes
    • Use date widget on same form using a +/- operator with a constant value of days/hours/minutes
    • Use date widget on same form using a +/- operator with another integer widget value of days/hours/minutes
  • Valid actions with Date datatype include:
    • Use Now with a +/- operator with a constant value of days/hours/minutes
    • Use Today with a +/- operator with a constant value of days days/hours/minutes.
    • Use Hour with a +/- operator with a constant value of days/hours/minutes
    • Use date widget on same form using a +/- operator with a constant value of days/hours/minutes
    • Use date widget on same form using a +/- operator with another integer widget value of days/hours/minutes