Compare two dates and times and times.
This condition is combined with other “when to execute” conditions.
For example, it is possible to check whether the “End Time” is within eight hours of the “Start Time.” You can set it to perform actions when this condition is met.
Set Comparing Time (A), Criteria, Comparing Time (B), Value to be Added to Time (B), and Calculate Type.
With these five parameters, for example
A >= B + 8 hours
and to set it as conditions.
If either “Comparing Time (A)” or “Comparing Time (B)” is empty, it will not result in an error, but the condition will be judged as “not satisfied.”
If both Comparing Time (A) and Comparing Time (B) are “date and time” with a date, they will be compared including the date. For example, the “Comparing Time (A) 2019-03-01 23:00” < Comparing Time (B) 2019-03-02 08:00" shows that if looking at only the time part, Comparing Time (A) is greater, but when considering the date as well, Comparing Time (B) is greater, so it is determined that the condition is satisfied.
If one of Comparing Time (A) or Comparing Time (B) is a date and time format with a date included, and another is a time format without a date, they are considered to be the same date. If a calculation is specified for Comparing Time (B), it will be aligned to the same date before the calculation. For example, the Comparing “Comparing Time (A)“2019-03-01 23:00” < Comparing Time (B) “21:00” + 4 hours” becomes ⇔ Comparing Time (A)“2019-03-01 23:00” < Comparing Time (B)“2019-03-01 21:00” + 4 hours" ⇔ “Comparing Time (A)“2019-03-01 23:00” < Comparing Time (B)“2019-03-02 01:00”, and it is determined that the conditions are satisfied. The “same day” will be the same day in the time zone set by “Set Time Zone”. If “Set Time Zone” is not set, it will be considered Japan Time.
Enter the time data to be compared.
To access the value of a Time field or a Date and time field, use the field code:
=Time_2
Remember to use an equals sign (=) before the field code to access the value of that field.
It is also possible to combine the date field and the time field. You can specify as follows:
=Date_1 & " " & Time_1
Remember to concatenate with a space in between. The time specified in this format is based on the time zone set by “Set Time Zone”. If “Set Time Zone” is not set, it will be considered Japan Time.
To specify the current time at the time of action execution enter:
=now()
This will set the current time as the value of this parameter.
Select comparison conditions.
The subject will be “Comparing Time (A)”. For example, if you choose “greater”, the condition will be “Comparing Time (A) is greater than B.”
Here, “greater” means “more future.”
Enter the time data to be compared.
The input method for referencing the values of date fields and datetime fields is the same as “Comparing Time (A).”
If you want to adjust the number of hours or minutes for B and then compare it with A, enter that value.
For example, to add three hours to “Comparing Time (B),” click the “Calculate Type” parameter, select “X Hours After” in the menu, and enter the value “3” in the “Value to be Added to Time (B)” parameter.
You can also use negative values. For example, if you set “Value to Add or Subtract to B” to “-3” and “Calculation Type (B)” to “X Minutes After”, the calculation will return the date three minutes before “Comparing Time (B)”.
To compare Comparing Time (B) without calculating it as is, do not input anything.
If the selection for “Calculate Type” is “Do not calculate,” the value entered here will not be used.
To add or subtract hours or minutes to Comparing Time (B) and then compare it with Comparing Time (A), select that unit.
Clicking the Condition Inverter will change the condition to “If comparing two times does not satisfy conditions.”
“If comparing two times does not satisfy conditions” will execute actions when the condition of the comparison result is not met.