Setup Record Selection for Previous Day

[kbrown73]

Crystal 8.5, Ingres Database, ODBC

I need to setup a record selection that will generate a report for the previous day from a given time frame, say today is Nov. 5, I need the report to extract records for Nov. 4 from 12:00am - 11:59pm of a record field called "start_time".

I do not want to use the parameter option because I need to schedule the report to run without user intervention.

Thanks in advance.

 

[kbrown73]

BTW, the start_time field is a Date-Time field

Ex: 11/4/2004 2:13:30PM

 

[kbrown73]

I posted too soon. I solved my own proplem by using this:

{start_time} = Currentdate - 1