Date Difference
Solution No. 22
This action compares the difference between two date/time values, and stores the outcome in an Action Result Variable that can be used in subsequent actions.
So Where Would We Use It?
Useful when comparing two date/time objects to calculate time difference for duration.
Properties
To set the properties for this action follow the example steps below:
1. Select Date Difference from the Action dropdown list.
2. Select first date from the dropdown list.
The choices are:
- Type In – sets the condition to a value that the user types in manually.
- Action Result – sets the condition to a user-defined action result.
- Value From Screen – sets the condition to a value pulled from a specific field within the specified screen.
- Value From Row – sets the condition to a value from a specified row.
3. If you selected Type In for Step 2, enter the predefined value and proceed to Step 4; otherwise, specify a Value in the dropdown list below.
4. Repeat steps 1-3 for Select second date from the dropdown list.
5. Select which days you wish to exclude.
6. Select the units to retrieve time difference in from the dropdown list.
The choices are:
- Seconds
- Minutes
- Hours
- Days
- Months
- Years
7. Enter an Action Result name.
8. Enter Internal note (Optional).
9. Click Save & Close to save changes and close the action properties window; otherwise, click Cancel to close the window without saving.
Created by | John C. on | Nov-19-2012 |
Last modified by | John C. on | Nov-19-2012 |