Finance | Project Operations, Human Resources, ...

Filtering Dates before Monday in D365 Grid View

(0) Share

Report

Posted on by MM-07050053-0

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)

All responses (5)

Answers (0)

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

Why do you start the whole discussion again (even with identical screenshots) if it was already discussed in Filtering dates before Monday?

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
MM-07050053-0 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
MM-07050053-0 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Filtering Dates before Monday in D365 Grid View

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.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Filtering Dates before Monday in D365 Grid View

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.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates