If you want to put the calculation result in another field, select that field in the “Set destination field (optional)” parameter.
Instead of placing the calculation results in the field immediately, if you want to use it in other actions, use mathematical expressions.
Adds or subtracts days, months, and years to a date. The results can be viewed from other action.
When you perform an action set to Calculate Dates, the date is stored internally as a result of the action.
You can use a formula to get the saved date, for example, = $1.
The saved date is in a format that can be set directly into the kintone date field. However, there is no time information, so you cannot set it to a date and time field.
Example) Example of using the result date as another action (to add a record)
Specify the Base Date, Right Side Value, and Calculated Content.
Enter the date on which you want to base.
If you want to refer to the value of a date or time field
=Date_2
Refer to the field code with “=” as shown in.
If you want to use the current date, use
=today()
in the Value field.
The number of days, months, and years that you want to add.
For example, if you want to calculate “3 months after the base date”, select “X months after” in “Calculated content” and set “Right side value” to “3”.
You can also enter negative values. If “Right side value” is set to “-3” and “Calculation content” is set to “X months later”, then “3 months before the base date” will be calculated.
Select from [X days after], [X weeks after], [X months after], or [X years after].
Specify this when setting the calculation result to another field. If you do not set it in the direct field but want to use the calculation result in another action, you can omit it.