Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Upgrading to Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
How can I do :
while select dateColumn1, dateColumn2 ....
where myTable.dateColumn1 >= myTable.dateColumn2 + 1 // **** I want to compare to date of column + 1 day. How can I do that?
// **** ....
You can use DateTimeUtil class method addDays.
Dont forget time stamps in datetime type fields. But still you can use the same DateTimeUtil class to manage with all hhmmss issues.
In select (AX 2009)?
I think I cannot use DateTimeUtils in select statment (or any function).
Anywise - for my question: How can I select the date without the time (time = 0, and date = same date as query).
conversion method used in select is not supported in AX.
you may get some idea with the blog on how you can achieve your requirement
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics