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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Filtering Dates before...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Filtering Dates before Monday in D365 Grid View

(0) ShareShare
ReportReport
Posted on by MM-07050053-0 10

I am in the Grid view for Work Orders in Asset Management.  I am trying to created a saved filter that will always filter for dates that are before Monday.  The screenshot below is a sample of the list.

Today is Monday, so the formula I want to use is (lessthandate(0)).  That works except it keeps blank values.
 
However, I want this formula to know that I want to filter before Monday of this week.  When I try to put in the day of week, I get an error: (lessthandate(1-dayOfWk(Today()))
I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 238,782 Most Valuable Professional on at
    Why do you start the whole discussion again (even with identical screenshots) if it was already discussed in Filtering dates before Monday?
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Hi,
    I think you may feel that the previous problem was not fully resolved, so you opened a new thread. But please keep one thread to prevent thread abuse.
    Best Regards,
    Hana
  • MM-07050053-0 Profile Picture
    MM-07050053-0 10 on at
    In the previous thread, I clicked on "Does this answer your question?".  I thought it would give me the option to answer yes or no, but instead it marked the thread solved.  I could not uncheck that box so I started a new thread.
  • MM-07050053-0 Profile Picture
    MM-07050053-0 10 on at
    How do I re-open this discussion?  The previous post was incorrectly marked complete (accidentally by me) so there has not been any follow up.  This post is not being addressed because there is a reference to another post.  The question has not been answered in a way that can be solved from the column header filter in the grid view.
  • Martin Dráb Profile Picture
    Martin Dráb 238,782 Most Valuable Professional on at
    You can contact a moderator in such a case. I've just removed the "Answered" flag from your original thread.

    By the way, you could have continued the discussion there even after marking it answered, couldn't you?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 514 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 390

#3
Adis Profile Picture

Adis 266 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans