Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Filtering Dates before Monday in D365 Grid View

(0) ShareShare
ReportReport
Posted on by 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()))
  • Martin Dráb Profile Picture
    Martin Dráb 230,848 Most Valuable Professional on at
    Filtering Dates before Monday in D365 Grid View
    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?
  • MM-07050053-0 Profile Picture
    MM-07050053-0 10 on at
    Filtering Dates before Monday in D365 Grid View
    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.
  • MM-07050053-0 Profile Picture
    MM-07050053-0 10 on at
    Filtering Dates before Monday in D365 Grid View
    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.
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Filtering Dates before Monday in D365 Grid View
    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
  • Martin Dráb Profile Picture
    Martin Dráb 230,848 Most Valuable Professional on at
    Filtering Dates before Monday in D365 Grid View
    Why do you start the whole discussion again (even with identical screenshots) if it was already discussed in Filtering dates before Monday?

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

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans