Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Represents the difference between two DateTimes. This value can be negative. It is stored as a 64-bit integer. The integer value is the number of milliseconds during the duration.
The following are examples of durations:
DATETIME-DATETIME=DURATION
DATETIME-DURATION=DATETIME
DATETIME+DURATION=DATETIME
Example
This example shows how to calculate the difference between two DateTimes. It requires that you define the following variables.
| Variable | DataType |
|---|---|
| DateTime1 | DateTime |
| Datetime2 | DateTime |
| Duration | Duration |
This example is run on a computer with the Current Format in the Regional and Language Options set to English (United States).
DateTime1 := CREATEDATETIME(010109D, 080000T); // January 1, 2009 at 08:00:00 AM
DateTime2 := CREATEDATETIME(050509D, 133001T); // May 5, 2009 at 1:30:01 PM
Duration := DateTime2 - DateTime1;
MESSAGE(FORMAT(Duration));
The message window displays the following:
124 days 4 hours 30 minutes 1 second