Dates [AX 2012]

Updated: February 28, 2012

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

The date data type holds a complete date; that is, day, month, and year.

The date data type can hold dates in the closed interval [1\1\1900; 31\12\2154], that is: between January 1, 1900, and December 31, 2154.

Date declaration


date Variable { , Variable } ;



Identifier [ option ]



arrayoptions | initialization

//Simple declaration of a date variable, d
date d; 
//Multiple declaration of two date variables
date d1, d2;
//A date variable, d3, is initialized to the 21st of November 1998
date d3 = 21\11\1998;
//Declaration of a dynamic array of dates
date d4[]; 

Dates can be written as literals in X++ by using the syntax:

Date literal = day \ month \ year

You must use four digits for the year.

Dates are not automatically converted into other types, but you can use integer values in the computation of dates. For example:

void myMethod()
    int anInteger;
    date aDate;
    // Sets the date variable adate to January 1, 1998
    aDate = 1\1\1998;

    // Sets the integer variable anInteger to 30.
    anInteger = 30;

    // Sets aDate to aDate + 30; that is the 31st of January 1998
    aDate = aDate + anInteger;

You can use dates in additions and subtractions when you are using the date as the principal type; that is, if you are subtracting from or adding to a date, like this:

date = date - integer or date = date + integer

You can also subtract two dates, and you can use dates in relational expressions.



Size of data type

32 bits

Scope of data type

[1\1\1900; 31\12\2154]

Default value

The default is the minimum value of 1\1\1900. The minimum value is treated as null by X++ SQL statements.

Implicit conversions


Explicit conversions

str2date, date2str, date2num, int2date

Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. Get your copy at the MS Press Store.

Community Additions