Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Dynamic Date Filter

Posted on by 1,392

Hi,   

Please There any way to set Filter dynamically (Always filter by current date ) ?

CD-Issue.JPG

*This post is locked for comments

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Dynamic Date Filter

    Unfortunately not. You would have to do that in code.

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Dynamic Date Filter

    Hi,

    You must create a new FlowFilter-field.

    Then, add the new FlowFilter-field to the Table Filter of the new FlowField.

    Add the new FlowField to a Page. In the OnOpen-Trigger of the page add this

    Rec.SETRANGE("New FlowFilter Field", TODAY);


    The calculation of the FlowField will consider this and return an appropiate value.

    Microsoft used this kind of implementation in the Item-Table, Field "Date Filter".

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans