Date Range Filter

(0) Share

Report

Posted on by George Dunning

Hi I am very new to Nav and I have a report that shows me all the open quotes we have in our system and I want to be able to see all the ones for the past month (30 days or even 7 days) only by document date. I know I can set the Document Date filter to a range by inputting the dates eg "1/7..31/7" but is there a way to have that as a rolling filter so that it always just shows the previous 30 days?

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Teddy Herryanto (Th... 13,488 Moderator on at

Like (0)

Report

RE: Date Range Filter

Try doing a document date filter

-30D..

You can then save the filter view to have it available on the menu.
Suggested answer

Suresh Kulla 47,029 on at

Like (0)

Report

RE: Date Range Filter

Add the code in the on open page trigger to calculate start date and end date using TODAY AND CALCDATE functions and apply the filter on document date using those calculated dates