SQL query to pull today's transactions
Posted on 2013-02-07
I have an access database that logs history using the =Now() function into a field called TimeStamp. I'd like a simple query to pull all records with a certain date, but since each record also has a time attached, all my results return blank.
I'm thinking ...
SELECT * from tblHistory WHERE TimeStamp = "02/07/13"
But the recordset returns empty because the underlying data is ...
02/07/2013 3:58:01 PM
02/07/2013 3:58:15 PM
02/07/2013 3:58:55 PM
02/07/2013 3:59:01 PM
02/07/2013 3:56:30 PM