Date filter in nav

bharathnan

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

lubost

Simply do
SETRANGE("Posting Date", CALCDATE('<-5Y>', TODAY), TODAY);

RockWithNAV

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.

lubost

Simply do
SETRANGE("Posting Date", CALCDATE('<-5Y>', TODAY), TODAY);

bharathnan

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