Date Filter for export to excel

buzfar

Hello;

I am new to Navision and need help exporting data from Navision into an excel document.

I need to filter by the date... I need all of a certain type of product (which I know how to filter by some fields and get content I want). I do not know how to filter by the date. I only want dates from 11/01/07 until present, today.

Can someone assist me with this?

Thank you

Allene

Revolution1210

11/01/07.. will filter from 11th January 2007 onwards

..11/01/07 will filter up until 11th January 2007

11/01/07..11/01/08 gives you everything between 11th January '07 and 11th January '08

Take a look at the online help (F1) in NAV, there is a section on constructing filters.

Also, don't forget you don't have to type the forward slashes in dates, NAV will insert these for you, so you can type 110107 instead of 11/01/07... ..makes typing a bit quicker

Hope this helps