Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum

Date filters for Views / Advanced Finds

(0) ShareShare
ReportReport
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,410 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.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans