Get a date from a range of dates at specified intervals and trigger the event “When an Element is Fetched from List”.
Extract one date from the range of dates specified by the parameters. The extracted date becomes the result value of the action, and “When an Element is Fetched from List” occurs. Please note that only one date will be extracted per action execution. To extract all dates within the range, you need to repeatedly perform the same action.
The date retrieved is stored, and “Get a Date from Date Range” is executed again with the same action number to retrieve the next date. At this time, the action result value is overwritten, and the previous result value is lost. If the action numbers are different, the dates will be stored separately for each action.
If all the dates up to the last date of the range have been retrieved, the action’s result value will be empty when you “Get a Date from Date Range.” In this case, “When an Element is Fetched from List” does not occur, instead, “When Fetching List is Finished” appears. In any case, “When Another Action Complete” occurs.
When extracting dates from the date range until the last date of the range, as mentioned above, the result of the action will be empty, but at this time, the extraction position will be reset. When executing “Get a Date from Date Range” again, the date is retrieved from the start of the range once more.
For example, if the date range is from 2022-05-01 to 2022-05-03 and the increment is 1 day, the result of repeated execution will be as follows: Time | Execution Result | When an Element is Fetched from List | When Fetching List is Finished —–|———|——————————-|———————————- 1st time | 2022-05-01 | Occur | Not occur 2nd time | 2022-05-02 | Occur | Not occur 3rd time | 2022-05-03 | Occur | Not occur 4th time | Empty | Not occur | Occur 5th time | 2022-05-01 | Occur | Not occur
In the above example, “When Another Action Complete ” occurs all five times.
Set Start Date, End Date, Incremental, Unit, and Day of the Week to Exclude.
Specify the start date of the range.
To access the value of a Date field or a Date and time field, use the field code:
Example: =Date_2
insert an equals sign “=” before the field code, as in the example.
To specify the current date, write as follows:
=today()
Specify the end date of the range.
Like the start date, it is possible to reference the values of date fields or datetime fields using expressions, or to specify the current date.
The end date is included in the range. However, if the result of adding the increment skips this day, the end date will not be included in the target.
Example:
To execute “Get a Date from Date Range” for subsequent times, specify the increment based on the previously extracted date as a number.
You can specify it in the formula.
Cannot be less than zero.
Select the unit of increment from Day, Week, or Month.
For example,to extract dates every 3 months, set the Increment to “3” and the Unit to “Month.”
If there are days of the week to skip when extracting, specify them. If nothing is in particular, select “Don’t Exclude.”
If you select anything other than “Don’t Exclude,” the extraction behavior will differ depending on the unit of increment.
The calculation of the date to be extracted next is based on the date extracted last time. This matter requires attention, especially when performing monthly extractions around the end of the month.
For example, suppose the start date is “2022-01-31” and the increment is “1 month.” The next date to be extracted after 2022-01-31, will be one month later on 2022-02-28. Then, the next one to be extracted will be 2022-03-28, which is one month after 2022-02-28. It is not 2022-03-31, which is two months after 2022-01-31.
To obtain the “end of the month”, set the start date to the beginning of the month, such as 2022-01-01, and then follow the procedure of extracting the beginning of the month date from the “Get a Date from Date Range” and obtaining the end of the month date from “Get Specific Date by Providing Date”.