Wildcard filter on datefield in query expression

This question is not answered

Hi forum

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).

Anyone?

 

Best regards, Ebbe

All Replies
  • 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.