Showing Today & Yesterday

[aj3221]

I have a report that is pulling on when an order was picked. It's running daily at 6am. I want it to pull anything picked today and yesterday. For some reason I cannot think of how to do this. I did a quick formula but it's taking the report a big longer to run which I think is because I don't have a lot of other criteria to pull on so it's looking at everything to try to get those dates. I know in the select expert you can choose a period but of course there isn't one for this. I wanted to do a quick formula right there but all I can think of is {oeeh1.pickeddt} = today-1. That shows yesterday but not today. I want it to be today and -1. Or yesterday +1.

 

[IanWaterman]

In Select expert

{oeeh1.pickeddt} >= today-1
and
{oeeh1.pickeddt} <= today

 

[aj3221]

It was that easy!? Why didn't I think of the "and". I'm such a dork. I totally overthought it. Thank you! I'm all set...and need a vacation I think.

 

[kenhamady]

Or like this:
{oeeh1.pickeddt} in today-1 to today

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/