You’re offline. This is a read only version of the page.
Hi
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?
*This post is locked for comments
Works like a charm!
Hi,
give it try with:
SETFILTER(Ending_Date, '>=%1|%2', TODAY, 0D);
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (