Date Formula 3

[sgd3476]

I have created a report that shows orders submitted by traders. I would like it to show only previous day's orders. I have many dates in the table to select from, I just don't know how to select previousday.

Thanks for any help.
Katie

 

[synapsevampire]

Try:

Report->Edit Selection Formula->Record

{table.date} = currentdate-1

Too simple, eh?

If thsi doesn't work, post technical information:
Crystal version
Database/connectivity used
Example data
Expected output

-k

 

[bdreed35]

If you only want to see the previous days records on your report, then use the following in your record selection:

{table.order_date} = currentdate-1

This will return only the previous days orders to your report.

~Brian

 

[sgd3476]

That did it! I'm sure you've heard it before, but you all are wonderful.

Thanks,
Katie