Skip to main content

Notifications

Dynamics 365 general forum
Suggested answer

How to have filter criteria in a view to show last rolling 12 months

Posted on by 2,645

I need to create a view that would show the Billed in last Rolling - 12 months.

How can I do this?  Not sure what option to pick in the filter area of the view.  Thank you.

  • Suggested answer
    RE: How to have filter criteria in a view to show last rolling 12 months

    Hello USA80,

    Hope you are well.

    Based on column that you would like to filter, you can choose a query relational operator for last months or year and achieve your need.

    See these articles:

    docs.microsoft.com/.../search

    docs.microsoft.com/.../advanced-find

    Regards,

  • AriaConsulting Profile Picture
    AriaConsulting 2,651 on at
    RE: How to have filter criteria in a view to show last rolling 12 months

    Hi, which D365 app are you using? And does billed=invoiced?

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans