Wildcard filter on datefield in query expression

(0) Share

Report

Posted on by Ebbe Høeg Jensen

150

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

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Martin Dráb 239,670 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Ebbe Høeg Jensen 150 on at

Like (0)

Report
Copy link

Link copied!

Thankyou. I believe you are right.

Was this reply helpful? Yes No