Round down the time by the specified number of minutes. The calculation result can be referred to in other Actions.
When you execute an Action set to run “Round Down Time,” the result of that calculation is stored internally. You can calculate the time using a formula, such as “=$1.”
If the value of the Time parameter is in a format that does not contain a date, the result of the calculation is formatted like 09:30. Seconds are not included. You can set it straight into the Kintone Time field. However, the saved data does not contain a date, so it cannot be exported to a “Date and time” field in Kintone.
If the Time parameter value includes a date, it is calculated inclusively, and the result is also included in a date format. The resulting format will be based on Coordinated Universal Time, such as 2019-09-06T03:16:00.000Z. This format can be set directly into the Kintone “Date and time” field.
Example: Re-using the calculated date in an Action that runs the Do “Add New Record.”
Set the Time and Round Down Minute.
Enter the time to be used in the date calculation.
The format can be time only and no date, such as 09:30, or both date and time, such as 2019-09-12 09:30.
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:
=Time_2
Remember to use an equals sign (=) before the field code to access the value of that field.
Use the syntax below if you want to use the current time.
=now()
This will set the current time as the value of this parameter.
Values that cannot be interpreted as empty values or dates cause an error at runtime.
Specify the round-down unit in minutes.
You must specify a number that divides 24 hours (1440 minutes). For example, 10, 15, 30 can be selected.
Values greater than 1 hour, such as 60 or 120 minutes, can also be specified.
Negative values are not allowed.
An expression cannot specify it.