How to compare two dates in MS Dynamics AX 2009?

Question

How to compare two dates (instances of type Date, not utcDateTime) in MS Dynamics AX 2009?

I want to check if particular date, taken from the table, is before (or after) the another one. Both are date types.

Is there a way to convert date to utcDateTime datatype?

"from the table"? Compare 2 dates in the same table or in two different tables. If needed copy your query to the question. — Jan B. Kjeldsen, Aug 12 '11 at 11:42

Jan B. Kjeldsen · Accepted Answer · 2011-08-15T10:00:43.523

How to compare two dates?

Use the comparison operators < <= >= > == and !=.

if (LedgerTrans.TransDate > systemDateGet() - 3)
    LedgerTrans.TransDate = systemDateGet() - 3;

This works in selects too:

select firstonly LedgerTrans 
    where LedgerTrans.TransDate > systemDateGet() - 3;

It works in query input ranges as well: >13-08 will select select dates after August 13'th of the current year. See also: http://kashperuk.blogspot.com/2010/02/utcdatetime-in-dynamics-ax-2009.html

How to convert a date to utcDateTime?

DateTimeUtil::newDateTime(systemDateGet(), 0, DateTimeUtil::getUserPreferredTimeZone()));

There is no need to convert Date to utcDateTime to compare two dates.

1 Answers1