Wondering if possible to search for all ledgertrans postings having date 11th of October not caring about the year?
Wondering if there is a built in and clever way to do this NOT by creating a method in class SysQueryRangeUtil returning say 100 dates to search for(11-10-1913,11-10-1914,11-10-1915,11-10-1916 and so on).
Best regards, Ebbe
In SQL Server, you could use something like where day(TransDate) = 11 and month(TransDate) = 10. I don't think you can do that with AX queries - you would have to resort to a direct SQL query.
Martin "Goshoom" Dráb | Freelancer | Goshoom.NET Dev Blog
Thankyou. I believe you are right.