Hi Softrak

A client wants to create a filter that shows all open PO's where the expected receipt date is in the past.

I couldn't figure out a way to do it without forcing them to edit the filter each time and change the target date. The closest I could come was to create a filter that showed PO's whose expected receipt dates were in the Last 30 Days.

Can you add "Today" as a field when building a filter and using the comparison option.

Thanks

Steve:

Today is available in PO as a Floating date range.

To get the results you want, and I would like to see as well, is something that will do Date < Today

Hi Steve/Doug,

I can make a suggestion to include new Filter floating date ranges of 'Before today' and 'After today', to take care of both possible scenarios.

Steve: You are correct that the Last 30 Days floating range is the best you can do right now.