Is there a way to create a filter for IC Items to show which items are currently on sale? We would like to use the criteria, "Sale End Date" "Greater than" "Today". However, "Today" is not an option. We have to select an actual date from the calendar.

We use IC Item Inquiry to quote customers prices all day long, but we can't recognize whether an item is on sale unless we look at the "Sale price", "Sale starts" and "Sale ends" fields every single time we look up an item and determine if those dates are current. This is far too tedious. The only workaround we know is to enter the item on an order in Order Entry, however, this is not practical either.

Is there any way we can identify the current sale items with a filter?