Try:
SELECT * FROM myTable WHERE purchaseDate BETWEEN @STARTDATE AND @ENDDATE
If you hand the two dates as parameters, and remember that BETWEEN is inclusive, then make STARTDATE yesterday at 0:0:0 and ENDDATE yesterday at 23:59:59 that should do what you want.