web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Date Range Filter

Microsoft Dynamics NAV (Archived)

Date Range Filter

(0) Share

Report

Report

Posted on by George Dunning

12

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,304 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Try doing a document date filter

-30D..

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

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1

TAHER_El_Mehdi 2

#1

#1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans