Date utilities decrement and increment
When you are creating a workflow with the
Development Studio application, the decrement and increment operations are used to decrement/increment the year, month, day, hour, minute, or second segment of a specified date by a defined value. The result is the modified date.
timestamps use epoch values in milliseconds (a variant of the Unix epoch, which is in seconds). For example, the epoch value 1055545912454 represents Jun 13 2003 23:11:52.454 UTC. When providing values, use this format. The results from this utility will be in this format.
To transform an epoch timestamp value to a traditional date string (such as Jun 13 2003 23:11:52.454 UTC), use the Basic transform editor Date Formatter function (see Basic-transform-editor-functions).
To transform an epoch timestamp value in milliseconds to an epoch timestamp in seconds, divide the value by 1000.
To configure a Utility activity to modify a date with an operation of increment or decrement
- On the Property Panel for the Utility activity, select date from the Utility type field menu.
- Select increment or decrement from the Operation type menu for the operation type.
- In the Date field, enter the date to be modified using a date in a context item or a date selected from the calendar.
Use one of the following steps:- To use a context item, in the Date field, choose Context item and then browse for and select the context item. The context item must be an epoch value in milliseconds.
To use a date, in the Date field, choose Date, click the Calendar button, select the date, and click OK to close the calendar. The date will be converted to an epoch value in milliseconds.
- In the Increment/Decrement by field, enter the value to be used to modify the specified date using a value in a context item or a numeric value.
Use one of the following steps:- To use a context item, choose Context item from the menu and then browse for and select the context item.
- To use a numeric value, choose Numeric from the menu and enter the number in the field.
- Use the Date Field menu to select the date segment for the increment/decrement field.
Click the Browse button associated with the output field to launch the context browser and select the context item for the result.
After assigning the date modification values, you must select a context item to contain the resulting date.
- When all the data has been entered, click OK.