Date Question

[fatboy02]

I receive a text file each morning that lists purchase orders created each day of the month for current month. So, today's report includes all orders created from 11/1/09 to 11/17/09. Is there a way I can filter or capture current date minus 1 day? Today I only want the orders that were created yesterday. Tomorrow I only want the orders that were created today. . .(Some of these orders need to be cancelled so that existing stock from other company locations can be utilized and identifying them as soon as possible after they are created is the best way to ensure that I can have them cancelled).

[OllyInMunich]

Hello Rob,

If you define a filter as:

[YourDateField]=Today()-1

that should do it.

Best wishes,

Olly

[fatboy02]

Thanks much Olly.