Crystal Date in a Record Selection

[GCL2007]

Using Crystal 11, I am trying to create an alert where I want my transaction date to pull from 22:00 two days prior until 23:30 the previous day. The report will run automatically at 7:00 AM each day. Any thoughts the best way I could put that date selection in the record selection? Thanks

 

[Charliy]

formula {@startdate}
beforereadingrecords;
currentdate-2

formula {@enddate}
beforereadingrecords;
currentdate-1

({table.date} = {@startdate} and {table.time} > time(2200) )
or
((table.date} = {@enddate} and {table.time} < time(2201) )