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