Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Selecting date filter for column headers nav2017

(1) ShareShare
ReportReport
Posted on by

Hi guys, 

I'm working on a grouping schedule in Nav2017 and I want to select a date filter for my column headers so that the input in the rows only show the data of certain dates. I'm fairly new to Navision so any tips or tricks are greatly appreciated! 

To specify a bit: 

Navforum.PNG

I want the columns 5, 6 and 7 to show only data from a specific range of dates. So when I open the table with the date filter of (for instance) a year, the columns adjust to their own specific date filters. Do I do this with some kind of formula? Or are their other methods? 

Thank you all in advance,

Ludo

*This post is locked for comments

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    13,637 Moderator on at
    RE: Selecting date filter for column headers nav2017

    It really depends on the date that you specify when running the account schedules.

    But you can play around with the comparison date formula.

    For example, to show June data, you can put -CY+6M on it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans