Every condition cell in decision table can have a different operator. These are the general operators which you can choose from:
How to use date operators
By choosing any of the operators, date and time are set to None, and the time zone is set to GTM+1:00.
Without choosing a specific Date or Time (at least one), you can not save the condition!
Even if you have a set Time zone.
Request input format
Request input must be in a specific format, which is shown below. The order of date, time and timezone, does not affect the result.
"date": "YYYY-MM-DD",
"time": "HH:MM",
"timezone": "+/-HH:MM"
Equals Operator (=)
Compares two date values. The equal operator compares:
Equal Operator examples:
[request value] = [table value]
"date": "2021-03-18" date: "2021-03-18"
"time": "08:53" = time: "08:53" //true
"timezone": "+01:00" timezone: "+01:00"
"date": "2021-03-17" date: "2021-03-17"
"time": null = time: null //true
"timezone": "+01:00" timezone: "+01:00"
"date": null date: null
"time": "08:53" = time: "08:53" //true
"timezone": "+01:00" timezone: "+01:00"
"date": "2021-03-18" date: "2021-03-18"
"time": "08:53" = time: null //false
"timezone": "+01:00" timezone: "+01:00"
"date": null date: "2021-03-18"
"time": "08:53" = time: "08:53" //false
"timezone": "+01:00" timezone: "+01:00"
Greater than OR Equal Operator (>=)
The greater than or equal operator (>=) returns true if the left operand is greater than or equal to the right operand, and false otherwise.
Greater than OR Equal Operator examples:
[request value] >= [table value]
"date": "2021-03-18" date: "2021-03-18"
"time": "08:53" >= time: "08:53" //true
"timezone": "+01:00" timezone: "+01:00"
"date": "2021-03-18" date: "2021-03-18"
"time": "09:53" >= time: "08:53" //true
"timezone": "+03:00" timezone: "+01:00"
"date": "2021-03-20" date: "2021-03-18"
"time": null >= time: null //true
"timezone": "+01:00" timezone: "+01:00"
"date": null date: null
"time": "08:53" >= time: "08:53" //true
"timezone": "+01:00" timezone: "+01:00"
"date": null date: null
"time": "08:53" >= time: "10:53" //false
"timezone": "+04:00" timezone: "+01:00"
"date": "2021-03-18" date: "2021-03-18"
"time": null >= time: null //false
"timezone": "+04:00" timezone: "+01:00"
"date": "2021-03-20" date: "2021-03-18"
"time": "08:53" >= time: null //false
"timezone": "+01:00" timezone: "+01:00"
"date": null date: "2021-03-18"
"time": "08:53" >= time: "08:53" //false
"timezone": "+01:00" timezone: "+01:00"
Greater Operator (>)
The greater operator (>) returns true if the left operand is greater than the right operand, and false otherwise.
Greater Operator examples:
[request value] > [table value]
"date": "2021-03-18" date: "2021-03-18"
"time": "09:53" > time: "08:53" //true
"timezone": "+01:00" timezone: "+01:00"
"date": "2021-03-20" date: "2021-03-18"
"time": "08:53" > time: "08:53" //true
"timezone": "+03:00" timezone: "+01:00"
"date": "2021-03-20" date: "2021-03-18"
"time": null > time: null //true
"timezone": "+01:00" timezone: "+01:00"
"date": null date: null
"time": "09:53" > time: "08:53" //true
"timezone": "+01:00" timezone: "+01:00"
"date": "2021-03-18" date: "2021-03-18"
"time": "08:53" > time: "08:53" //false
"timezone": "+01:00" timezone: "+01:00"
"date": null date: null
"time": "10:53" > time: "08:53" //false
"timezone": "+04:00" timezone: "+01:00"
"date": "2021-03-18" date: "2021-03-18"
"time": null > time: null //false
"timezone": "+04:00" timezone: "+01:00"
"date": "2021-03-20" date: "2021-03-18"
"time": "08:53" > time: null //false
"timezone": "+01:00" timezone: "+01:00"
"date": null date: "2021-03-18"
"time": "08:53" > time: "08:53" //false
"timezone": "+01:00" timezone: "+01:00"
Less than OR Equal Operator (<=)
The less than or equal operator (<=) returns true if the left operand is less than or equal to the right operand, and false otherwise.
Less than OR Equal Operator examples:
[request value] <= [table value]
"date": "2021-03-18" date: "2021-03-18"
"time": "08:53" <= time: "08:53" //true
"timezone": "+01:00" timezone: "+01:00"
"date": "2021-03-18" date: "2021-03-18"
"time": "07:53" <= time: "08:53" //true
"timezone": "+03:00" timezone: "+01:00"
"date": "2021-03-10" date: "2021-03-18"
"time": null <= time: null //true
"timezone": "+01:00" timezone: "+01:00"
"date": null date: null
"time": "08:53" <= time: "08:53" //true
"timezone": "+01:00" timezone: "+01:00"
"date": null date: null
"time": "08:53" <= time: "10:53" //false
"timezone": "-04:00" timezone: "+01:00"
"date": "2021-03-18" date: "2021-03-18"
"time": null <= time: null //false
"timezone": "-04:00" timezone: "+01:00"
"date": "2021-03-20" date: "2021-03-18"
"time": "08:53" >= time: null //false
"timezone": "+01:00" timezone: "+01:00"
"date": null date: "2021-03-18"
"time": "08:53" <= time: "08:53" //false
"timezone": "+01:00" timezone: "+01:00"
Less than Operator (<)
The less than operator (<) returns true if the left operand is less than the right operand, and false otherwise.
Less than Operator examples:
[request value] < [table value]
"date": "2021-03-18" date: "2021-03-18"
"time": "07:53" < time: "08:53" //true
"timezone": "+01:00" timezone: "+01:00"
"date": "2021-03-10" date: "2021-03-18"
"time": "08:53" < time: "08:53" //true
"timezone": "+03:00" timezone: "+01:00"
"date": "2021-03-10" date: "2021-03-18"
"time": null < time: null //true
"timezone": "+01:00" timezone: "+01:00"
"date": null date: null
"time": "07:53" < time: "08:53" //true
"timezone": "+01:00" timezone: "+01:00"
"date": "2021-03-18" date: "2021-03-18"
"time": "08:53" < time: "08:53" //false
"timezone": "+01:00" timezone: "+01:00"
"date": null date: null
"time": "07:53" < time: "08:53" //false
"timezone": "-04:00" timezone: "+01:00"
"date": "2021-03-18" date: "2021-03-18"
"time": null < time: null //false
"timezone": "-04:00" timezone: "+01:00"
"date": "2021-03-20" date: "2021-03-18"
"time": "08:53" < time: null //false
"timezone": "+01:00" timezone: "+01:00"
"date": null date: "2021-03-18"
"time": "08:53" < time: "08:53" //false
"timezone": "+01:00" timezone: "+01:00"
Not Equal Operator (<>)
Compares two dates. The not equal operator compares:
Not Equal Operator examples:
[request value] <> [table value]
"date": "2021-03-18" date: "2021-03-18"
"time": "08:53" <> time: "08:53" //false
"timezone": "+01:00" timezone: "+01:00"
"date": "2021-03-17" date: "2021-03-17"
"time": null <> time: null //false
"timezone": "+01:00" timezone: "+01:00"
"date": "2021-03-18" date: "2021-03-18"
"time": "08:53" <> time: null //false
"timezone": "+01:00" timezone: "+01:00"
"date": null date: "2021-03-18"
"time": "08:53" <> time: "08:53" //false
"timezone": "+01:00" timezone: "+01:00"
"date": "2021-03-20" date: "2021-03-18"
"time": "08:53" <> time: "08:53" //true
"timezone": "+01:00" timezone: "+01:00"
"date": null date: null
"time": "10:53" <> time: "08:53" //true
"timezone": "+01:00" timezone: "+01:00"
Between Operator (between)
The between operator (between) returns true if the left operand is between or equal to the right operand, and false otherwise.
Between Operator examples:
[request value] between [table value]
date: "2021-03-18"
time: "08:53"
"date": "2021-05-18" timezone: "+01:00"
"time": "08:53" between AND //true
"timezone": "+01:00" date: "2022-03-18"
time: "08:53"
timezone: "+01:00"
//----------------------------------------------------------
date: "2021-03-18"
time: "08:53"
"date": "2021-03-18" timezone: "+01:00"
"time": "08:53" between AND //true
"timezone": "+01:00" date: "2021-03-18"
time: "08:53"
timezone: "+01:00"
//----------------------------------------------------------
date: "2021-03-18"
time: "08:53"
"date": "2021-05-18" timezone: "+01:00"
"time": "14:53" between AND //true
"timezone": "+05:00" date: "2021-03-18"
time: "08:53"
timezone: "+01:00"
//----------------------------------------------------------
date: null
time: "08:53"
"date": null timezone: "+01:00"
"time": "14:53" between AND //true
"timezone": "+01:00" date: null
time: "20:53"
timezone: "+01:00"
//----------------------------------------------------------
date: "2021-03-18"
time: null
"date": "2021-09-18" timezone: "+01:00"
"time": null between AND //true
"timezone": "+01:00" date: "2022-03-18"
time: null
timezone: "+01:00"
//----------------------------------------------------------
date: "2021-03-18"
time: "08:53"
"date": "1999-03-18" timezone: "+01:00"
"time": "08:53" between AND //false
"timezone": "+01:00" date: "2021-03-18"
time: "08:53"
timezone: "+01:00"
//----------------------------------------------------------
date: "2021-03-18"
time: "08:53"
"date": "2021-06-18" timezone: "+01:00"
"time": null between AND //false
"timezone": "+01:00" date: "2022-03-18"
time: "08:53"
timezone: "+01:00"
//----------------------------------------------------------
date: "2021-03-18"
time: "08:53"
"date": null timezone: "+01:00"
"time": "08:53" between AND //false
"timezone": "+01:00" date: "2022-03-18"
time: "08:53"
timezone: "+01:00"
