Job Runner

Remove Time From Date and Time

Overview

Remove the time portion from the date and time, leaving only the date. The calculation result can be referred to in other Actions.

Usage

When you execute an Action set to run “Remove Tme From Date and Time,” the calculation’s result is stored internally. You can get the calculated date using a formula, for example, “=$1.”

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.

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

1. Set an Action that runs the Do “Remove Time From Date and Time.” 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 “Remove Time From Date and Time” is “2”, change the formula to “=$2”.)

Parameters

Set Date and Time.

Date and Time

Enter a date and time.

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

=Date_1

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

Values that are empty or cannot be interpreted as time will cause an error at runtime.