Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content

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

© 2015 Microsoft