currentdate - 1 is a good start.
Quote:
> I am using Crystal Reports 8 and seagate info 7
> I need to be able to select all records with a create date of yesterday in
a
> scheduled report that runs daily for the previous days records.
> Is there some function i can use.
> This information is being pulled from Remedy which uses Oracle Database.
> Thanks.
> Shari
> if you can email me the answer i would appreciate it.
Date Range Question