A client using OE 9.2A (160707) wants to create a filter called "Late Ship" that displays all open orders whose Expected ship date is earlier than Today, sorted by Expected ship date.

I assume that is a case for using the Floating Date criterion, but exactly how to I do it?

Steve

Hi, Steve,

Floating dates are based on the session date used to log into the module. Sounds like you'd want to use the Expected Ship Date field floating the 'Before today' value. There's a similar filter example in OE sample data that uses 'This week'.

You'd also want to add criteria for whether the order is complete or not.

Thanks, I figured it out as I was writing. I didn't realize I had hit post!