sql select from "yesterday"

[Winfried Heilmann]

Hi,

for reporting I work with sql select.

Can anybody tell me, how I can do a select from a table (for example
actlog) only with the record from yesterday or the day before yesterday?

I can select the records from today with

select  ..................................where date(date_time)=current
date .

regards winfried