Date filter in nav

bharathnan
bharathnan Member Posts: 92
in NAV/Navision Classic Client
Hi all,
Good day,
I have created a report to show the invoices of all customers for the last five years, now I am able to filter the invoices only for the report and I am unable to filter the dates. Can anyone help me on how to filter the date for last five years from the current date.
Thanks in advance
Regards
Bharath k

Best Answer

Answers

  • RockWithNAV
    RockWithNAV Member Posts: 1,172
    edited 2018-03-08
    LastFiveYearDate =
    DMY2DATE(DATE2DMY(TODAY,1),DATE2DMY(TODAY,2),DATE2DMY(CALCDATE('<-CY-5Y>',TODAY),3));

    LastFIveYearDate = MESSAGE('%1',CALCDATE('<-5Y>',TODAY));

    This will return you the last 5 year date from current date. LastFiveYearDate is a date variable. Both will have same output.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • bharathnan
    bharathnan Member Posts: 92
    Thanks for your reply guys,
    Now one more thing ,I want to add no. Of invoice field from the customer table to the current report and it should show only invoices for the last 3 months .Can anybody help me...MOreover it should include all the invoices which has been shipped and not shipped also.
    Thanks in advance .
    Warm regards,
    Bharath

Categories