10
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?
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
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...
290,554
Super User 2024 Season 2
#2
Martin Dráb
228,588
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (