Check whether the specified date falls within a certain date range. The time part will be ignored.
This condition is combined with other “when to execute” conditions.
For example, you can set it to perform an action only if a certain date falls between the “Start Date” and the “End Date.”
Set Checking Date and Start Date, and End Date. You cannot leave any of them blank.
If the “Checking Date” falls between the “Start Date” and the “End Date”, the condition is met. The condition is also met if the “Checking Date” is the same as the “Start Date” or “End Date”.
Enter the date data to be compared.
To access the value of a Date field or a Date and time field, use the field code:
=Date_2
Remember to use an equals sign (=) before the field code to access the value of that field.
To specify the current date, enter
=today()
This will set the current date as the value of this parameter.
Enter the start date.
Just like the “Checking Date”, it is also possible to specify the value of the field or the current date using a formula.
Enter the end date.
Just like the “Checking Date”, it is also possible to specify the value of the field or the current date using a formula.
If you specify date data with time for “Check Date”, “Start Date”, and “End Date”, the date will be viewed in the time zone set by “Set Time Zone”. If “Set Time Zone” is not set, it will be considered Japan Time.
The time part is not taken into account during comparison. For example, if the “Checking Date” is 2020-09-18 05:00:00, and the start to end time is from 2020-09-18 10:00:00 to 2020-09-19 00:00:00 (all in Japan time), it may seem that the conditions are not met when considering the time as well. However, the range will be checked whether “2020-09-18 falls within the range of 2020-09-18 to 2020-09-19” without considering the time part. It is determined that “the conditions are met.”
Clicking the Condition Inverter will change the condition to “If the date is not within the range.”