Registered: 06/15/04
Posts: 3611
Loc: Toronto ON, Canada
Andrew & Doug: My answer would be the same as Doug. Include i) all Invoices with a due date <= Date#1 and ii) all Invoices with a discount date >= Date#2 and <= Date#3. That requires one more date field than currently exists on the selection screen.
The client who pointed this issue out to me said she would be happy to revert to the old model. That seems like a reasonable short-term solution.