Date filter in nav

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

  • RockWithNAVRockWithNAV Member Posts: 1,139
    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.
  • bharathnanbharathnan 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
Sign In or Register to comment.