Date Calculation
Description
When using this part, the system returns the result achieved by adding or subtracting a specified number of days, hours, minutes, and seconds to or from a specified date and time.
Use
This part allows users to have the system calculate a date in the future or past when given another date; for example, the system can identify the date of a next appointment if an end-user is required to have appointments every two weeks. The user could also employ this part to determine a past date; for example, the system can determine a past date and use it as milestone date against which to compare a transactional date (e.g. flag as late if TODAY > Book Rental Date plus 14 days).
In this part, the user can specify the number of days, hours, minutes, and seconds to use for the calculation, or the user can identify data objects the system should use for the calculations. This could, for example, allow the user to have the system create a loop that separates invoices into past due "buckets" (30 days past due, 90 days past due, 180 days past due, etc.).
Editor Fields
| Field Name |
Description/Use |
Type/Options |
Optional/Mandatory |
| Start Date |
This is the field that contains the start date to be used. It should be entered in the $() format. |
Data Object |
Mandatory |
| Result Date |
This is the data object resulting from the calculation. It is not entered in the $() format. |
Data Object |
Mandatory |
| Operation |
This is the operator for the system to use in the calculation: either add or subtract from the start date. |
Add | Subtract |
Optional |
| Days |
These are the numbers the system will use in the calculation. You can enter specific numbers in the fields or use data object variables in the application. Each field is optional. |
Number or Data Object |
Optional |
Example
For a simple example of the date_calculation part, download and import the following sample project in your workspace.