Job Runner

Get a Date on the Day of the Week

Overview

Get a specific date based on a provided date to reference from other actions.

Usage

When you execute an Action set to run “Get a Date on the Day of the Week”, the result of that calculation is stored internally.

You can calculate the date using a formula, for example, “=$1”.

The saved date is formatted to be exported to a “Date” field in Kintone without modifications.

Example: Using the calculated date in an Action that runs the Do “Add New Record.”

1. First, set an Action that runs the Do “Get a Date on the Day of the Week.” Assume that the Action Number is “1.”
2. Next, open the “Mapping” menu of “Add New Record”, find the “Date” field that should receive the calculated date and enter the formula “=$1.” (If the Action Number of “Calculate Date” is “2”, change the formula to “=$2”.)

The date is interpreted according to the time zone setting set in Set Time Zone. If you haven’t “Set Time Zone,” it will be JST.

Parameters

Set Target and Day of the Week.

Target

Choose from this week, next week, last week, next, or previous.

The beginning of the week is calculated as Sunday. For example, if today is 2018-07-04 (Wed), “this Sunday” will be 2018-07-01 (Sun).

“Next” doesn’t mean next week, but the next day of the week. The same is true for “Before.” For example, if today is Wednesday, 2018-07-04, specifying “Next Friday” will result in Friday, 2018-07-06. On the other hand, if you specify “Next Friday,” it will be Friday, 2018-07-13.

“Next” doesn’t include today, and the same is true for “Before.” For example, if today is Wednesday, 2018-07-04, and you specify “Next Wednesday,” the result will be Wednesday, 2018-07-11, instead of Wednesday, 2018-07-04.

Day of the week

Specify the day of the week.