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!