Check whether the specified time falls within a certain time range.
This condition is combined with other “when to execute” conditions.
For example, you can set it to perform an action only if a certain time falls between the “Start Time” and the “End Time.”
Set Checking Time, Start Time, End Time, and Whether to check with date. You cannot leave any of the time fields blank.
If the “Checking Time” falls between the “Start Time” and the “End Time”, the condition is met. The condition is also met if the “Checking Time” is the same as the “Start Time” or “End 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. In this case, the time will be 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, enter
=now()
This will set the current time as the value of this parameter.
Enter the start time.
The input method for referencing the values in the time or the date and time fields is the same as “Checking Time.”
Enter the end time.
The input method for referencing the values in the time or the date and time fields is the same as “Checking Time.”
Specify whether to check the range including the date when the Checking Time, Start Time, and End Time include a date.
In the case of “Compare only the time part,” even if the date is included in Checking Time, Start Time, and End Time, the date part will be removed and only the time part will be compared.
For example, if the Checking Time is “2019-11-17 10:00,” the Start Time is “2019-11-18 08:00,” and the End Time is “2019-11-20 18:00,” the “Compare with date” option will judge it as out of range, but the “Compare only the time part” option will check “10:00” and “08:00 to 18:00,” so it will be within range, and the conditions will be met.
In the case of “Compare with date,” the method of checking changes depending on whether the date is included in each of the Checking Time, Start Time, and End Time.
If the Start Time is in the future compared to the End Time, caution is required.
Clicking the Condition Inverter will change the condition to “If the time is not within the range.”