Remove the date portion from the date and time, leaving only the time. You can reference the result from other actions.
To set the result of the calculation to another field, enter the target field into the parameter “Target Field (Optional)”.
Use formulas when using the results for other actions without setting the results to another field immediately.
When you execute an Action set to run “Remove Time From Date and Time”, the result of that calculation is stored internally. You can get the saved results by using a formula, for example “=$1”.
The date and time are interpreted in the time zone of the logged-in user.
Example: Use the calculated time results in another action, “Add New Record.”
Set Datetime and Target Field (Optional).
Enter the date and time.
To access the value of the date and time field, enter the field code as follows:
Example: =Datetime_1
insert an equals sign “=” before the field code, as in the example.
If the value is empty or cannot be interpreted as a time, an error will occur at runtime.
Use this parameter to set the results to another field. You can leave this parameter empty to use the calculation result in another action without setting it to any field.
If you select a field inside a table, all rows of that table will be processed. For exceptions: See (*1)
*1: Only the affected rows will be processed if you set a condition that applies only to some table rows (such as “When Fields Value Changed”).
This parameter accepts the following field types:
This action is designed to work seamlessly with krewSheet.
However, the following restrictions apply to the parameter “Target Field (Optional):”