Hi. First, how do i query all records for the current date? Second, how do i query all records from the previous day?

i.e. this is my table

table clients (
name char(25),
cid char(8),
email char(25),
tel char(10),
date datetime
);

Thanks.