Date difference
Solution No. 138
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 in date/time functions, the Date Difference action compares two date/time objects to calculate time difference for duration. The difference can be saved as an Action Result and used later.
Properties
To set the properties for this action, follow these steps:
1. Select Date Difference from the Action dropdown list.
2. Select First Date from the dropdown list.
- Type In – sets the condition to a value 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 pulled from a specific row within the specified grid.
3. Select Second Date from the drop down list. The choices are the same as above.
4. If you selected Type In for Step 2 and 3, enter the predefined value and proceed to Step 4; otherwise, choose which dates to Exclude, if any.
5. Select Retrieve difference in from the dropdown list.
The interval choices are:
- Seconds
- Minutes
- Hours
- Days
- Months
- Years
6. Enter Action Result name.
7. Enter Internal note (Optional).
8. Click Save & Close to save changes and close the action properties window; otherwise, click Cancel to close the window without saving.
| Created by | Saudia A. on | Oct-19-2011 |
| Last modified on | Sep-17-2015 |
