Wildcard filter on datefield in query expression

Question Status

Ebbe Høeg Jensen asked a question on 10 Oct 2013 8:34 AM

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



Best regards, Ebbe

Martin Dráb responded on 11 Oct 2013 1:35 AM

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.

Ebbe Høeg Jensen responded on 11 Oct 2013 3:23 AM

Thankyou. I believe you are right.