Duration Data Type in Dynamics NAV

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

See Also

DateTime Data Type