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

Selecting date filter for column headers nav2017

(1) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (1)

Answers (0)

Suggested answer

TeddyH 12,868 Super User 2024 Season 1 on at

Like (0)

Report

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.