I am trying to design a query in NAV with dynamic date filters like T-2M..T for transactions happened in the last 2 months
Also to add is a filter like >=T|'' for documents with a date in the future and where date field in empty
I can'r replicate the NAV sintax when applying filters to the query and thought if using SETFILTER in C\AL
I tried the below
SETFILTER(Ending_Date, '>=%1|%2', TODAY, '');
But it only returns records with Ending date greater and equal to today and it does not show the one with no date
Is this a syntax error?
give it try with:
SETFILTER(Ending_Date, '>=%1|%2', TODAY, 0D);
Works like a charm!
Business Applications communities