Setting a time range 1

[Maker1]

I am using crystal 10. Is is possible to set up a report that runs from 6 am yesterday to 6 am today? I need to have that as the default time range, so that when the report is run it uses that time frame without the end user needing to put in any data.

 

[lbass]

Try a record selection formula like:

{table.datetime} in datetime(currentdate-1,time(6,0,0)) to datetime(currentdate,time(5,59,59))

-LB

 

[Maker1]

Thanks MUCH!! I knew there was a way to do that just couln't find it. Have a star!