Date Operations
See the changelog of this Action type here.
Overview
Perfrom a list of operations on date fields.
In order to configure this Action, you must first link it to a Listener. Go to Building a Pipeline to learn how to link.
Ports
These are the input and output ports of this Action:
Output ports
Default port - Events are sent through this port if no error occurs while processing them.
Error port - Events are sent through this port if an error occurs while processing them.
Configuration
Find Date Operations in the Actions tab (under the Transformation group) and drag it onto the canvas.
To open the configuration, click the Action in the canvas and select Configuration.
Enter the operation and the required parameters:
Add duration
Timestamp* - Select the field from the Listener or Action that contains the timestamp value.
Duration* - Select the field from the Listener or Action that contains the duration value.
Unit* - Select the unit of measurement (milliseconds, seconds, minutes, hours, days) used to calculate the new date.
Output field* - Give a name to the output field with this new value.
Subtract duration
Timestamp* - Select the field from the Listener or Action that contains the timestamp value.
Duration* - Select the field from the Listener or Action that contains the duration value.
Unit* - Select the unit of measurement (milliseconds, seconds, minutes, hours, days) used to calculate the new date.
Output field* - Give a name to the output field with this new value.
Timestamp difference
Timestamp* - Select the field from the Listener or Action that contains the timestamp value.
Timestamp 2* - Select the field from the Listener or Action that contains the timestamp to compare against.
Result Unit* - Select the unit of measurement (milliseconds, seconds, minutes, hours, days) used to calculate the new date.
Output field* - Give a name to the output field with this new value.
Click Save to complete the process.
Last updated
Was this helpful?