web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Date filter in nav
Microsoft Dynamics NAV (Archived)

Date filter in nav

(0) ShareShare
ReportReport
Posted on by bharathkarunakaran 475

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

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Date filter in nav

    (StartDate - Variable - Date)

    StartDate := CALCDATE('<-5Y>',TODAY);

    "Customer".SETFILTER("**** Date",'%1..%2', StartDate,TODAY);

    Please mark the answer verified if it helped you. Thanks! Happy NAVing ;)

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 8,006 Super User 2025 Season 2 on at
    RE: Date filter in nav

    Hey,

    Check this out. A little hint. I believe now you will do of your own.

    msdn.microsoft.com/.../dd301368.aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans