web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Selecting date filter ...

Microsoft Dynamics NAV (Archived)

Selecting date filter for column headers nav2017

(1) Share

Report

Report

Posted on by Community Member

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:

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

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

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

Like (0)

Report
Copy link

Link copied!

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.

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