Using date utilities
When you are creating a workflow with the
Development Studio application, you can use the date utilities to perform the following activities: after, before, between, decrement, increment, and now.
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 working with date utilities, provide values in this format and expect operation results in this format.
To transform an epoch timestamp result from these utilities 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.
Date utility operations
Operation | Description |
|---|---|
Given two dates, Date 1 and Date 2, this function checks to see whether Date 1 comes after Date 2. | |
Given two dates, Date 1 and Date 2, this function checks to see whether Date 1 comes before Date 2. | |
Given two dates, Date 1 and Date 2, this function checks to see whether a specified Date falls between Date 1 and Date 2. In this case, the operation checks the following: Date 1 < Date < Date 2. | |
Decreases the specified date in the Date field by the unit value entered. For example, if you choose to decrement the month segment of a Date value by a unit of 2, 03/20/2008 13:45:00 (1206035100000 in epoch milliseconds) becomes 01/20/2008 13:45:00 (1200854700000 in epoch milliseconds). Times in this example are GMT -4 hours. | |
Increases the specified date in the Date field by the unit value entered. For example, if you choose to increment the year segment of a Date value by a unit of 1, 03/20/2008 13:45:00 (1206035100000 in epoch milliseconds) becomes 03/20/2009 13:45:00 (1237571100000 in epoch milliseconds). Times in this example are GMT -4 hours. | |
The current date, as of when this Utility activity is processed at run-time, is assigned to the Output context. |
This section contains the following topics: