Query Less than 1 day old

[bunji]

I have a field that stores the date in. I would like to query the records that show only the those that are less than one day old. e.g. Only show those that are for today and yesterday.

I have tried = Date()-1 but didnt seem to work. Any Ideas

 

[Brianwarnock]

How did it fail
try >Date()-1

 

[bunji]

Dor some reason it was showing all the records but what you wrote worked.

Many Thanks