Date utilities between
When you are creating a workflow with the
Development Studio application, use the between operation to determine if a specified date falls between the values defined for two additional dates. The comparison result is a string value of "true" or "false."
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. Entries that you choose in the calendar are converted to epoch values.
To configure a Utility activity that compares two dates to a third date with an operation of between
- On the Property Panel for the Utility activity, select date from the Utility type menu.
- Select between for the operation type.
- Enter the date to be evaluated in the Is Date field 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, choose Context item from the menu and then browse for and select the context item. The context item must be an epoch value in milliseconds.
To use a date, choose Date from the menu, 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 Between Date 1 and the and Date 2 fields, enter the dates to be compared using dates in context items or dates selected from the calendar. Select the inclusive box to the right of the date field to indicate that the date to be evaluated can be equal to date 1 or date 2 and still generate an output value of true.
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 date, choose Date from the menu, 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.
Click the Browse button associated with the output field to launch the context browser and select the context item for the result.
When you have assigned values to the date fields, you must select a context item to contain the results of the comparison.
- After entering all of the data, click OK.