Can anyone give me a SQL command to delete all records from the databse where Date = today-1?

Thanks