
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)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.