Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Unanswered

Date filters for Views / Advanced Finds

Posted on by Microsoft Employee

I am working on a client's shipping process and have the need for a view to show Orders that are in a specific status that have a Requested Ship Date of today or earlier.  By "today", I do not mean a specific date.  I also don't want to qualify Orders that have a Requested Ship Date greater than today so the use of the "Anytime" option is not the solution.  I thought this was a simple request; however, I've run into some obstacles and while I've found a work-around that works, the solution should be simpler than this. 

In the advanced find (or view filter), I put in the condition of "Requested Ship Date" and "Older than X Days" with a value of zero.  However, 0 (zero) is not a valid value.  An error is displayed stating the range is from 1 to 500.   I then used the "Today" option and an "OR" condition with "Older than X Days" set to "1" (one).  The issue is that if I have a Requested Ship Date of yesterday on an order, the "older than 1 days" doesn't qualify the order record with the Requested Ship Date of yesterday. 

I ended up using the "Last X Days" option with a value of 180 and that qualifies the order with yesterday's date on it. 

Is the issue with using "Older than X Days" with a value of 1 a bug?  Is there a reason that the range can't be from "0 to 500"?  As an alternative, another option could be created, "Order than Today", so the "Today" and "Older than Today" could be used together to qualify the data.   

The "Last X Days" is not a great solution because if a user has a typo and puts in a date from 2 years ago (Last X Days also has a valid range of 1 to 500), the order would not appear in the view. 

Has anybody else run into this issue?  Is there already an enhancement request along this line or should an enhancement request be created?  I'd appreciate your feedback.  Thank you!

  • RaviKashyap Profile Picture
    RaviKashyap 55,406 on at
    RE: Date filters for Views / Advanced Finds

    I think I had the similar requirement and I achieved this by using Last X Years and put 99. This way i got all the required records.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans