Date filter in nav

(0) Share

Report

Posted on by bharathkarunakaran

475

Hi all,
Good day,
I have created a report to show the invoices of all customers for the last five years, now I am able to filter the invoices only for the report and I am unable to filter the dates. Can anyone help me on how to filter the date for last five years from the current date.
Thanks in advance
Regards
Bharath k

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

RockwithNav 8,637 Super User 2025 Season 2 on at

Like (0)

Report

Hey,

Check this out. A little hint. I believe now you will do of your own.

msdn.microsoft.com/.../dd301368.aspx

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

(StartDate - Variable - Date)

StartDate := CALCDATE('<-5Y>',TODAY);

"Customer".SETFILTER("**** Date",'%1..%2', StartDate,TODAY);

Please mark the answer verified if it helped you. Thanks! Happy NAVing ;)

Was this reply helpful? Yes No