Get Specific Date by Providing Date

Overview

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

When you execute an Action set to run “Get Specific Date by Providing Date,” the calculation’s result is stored internally.

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

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

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

Set an Action that runs the Do “Get Specific Date by Providing Date.” Assume that the Action Number is “1.”
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 for “Get Specific Date by Providing Date” is #2, change the formula to “=$2”.)

Set Base Date and Date Format.

Enter the start date to be used in the date calculation.

If you want to access the value of a “Date” field or a “Date and time” field, input the field code as shown in the example below:

=Date_2

Remember to use an equals sign (=) before the field code to access the value of that field.

Values that cannot be interpreted as empty values or dates cause an error at runtime.

Select the date you want to get, such as a previous day or early next month.

You can choose from the following:

The fiscal year range is fixed from April to March. You cannot get the fiscal start date in a different fiscal range.