Dynamic date filter Query design

(0) Share

Report

Posted on by Community Member

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

All responses (2)

Answers (1)

Helpful resources