How to select only records from the last day, but last day is not known.

[sKunKbad]

I'd like to query the database for appointments that were made, but only the last day that they were made. The last day might not be today or yesterday, but it could be today or yesterday. I'd like to not have to do a separate query to determine this date. Can this be done? I'm already sorting the query by another column in case it matters. Any help is appreciated.

[Barand]

SELECT ... FROM mytable

WHERE date =  (SELECT MAX(date) FROM mytable)

[sKunKbad]

That was fast. Thank you!