<div>
try<br />
<br />
select * from tblhistory where convert(varchar, timestamp, 101) = &quot;02/07/13&quot;<br />
<br />
EDIT:<br />
<br />
I failed to see that you're in access, so you might have to try this:<br />
<br />
select * from tblhistory<br />
WHERE timestamp &gt;= #2013-02-07# and Licenses.Entereddate &lt;&nbsp;#2013-02-08#
</div>


try

select * from tblhistory where convert(varchar, timestamp, 101) = "02/07/13"

EDIT:

I failed to see that you're in access, so you might have to try this:

select * from tblhistory
WHERE timestamp >= #2013-02-07# and Licenses.Entereddate < #2013-02-08#

<div>
BTW,<br />
<br />
I would get out of the habit of calling it a [TimeStamp] as that has a very specific meaning in SQL Server. &nbsp;I use [LastModified]
</div>


BTW,

I would get out of the habit of calling it a [TimeStamp] as that has a very specific meaning in SQL Server.  I use [LastModified]

<div>
<div class="content wysiwyg-content">
I have an access database that logs history using the =Now() function into a field called TimeStamp. &nbsp;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.<br />
<br />
I'm thinking ...<br />
<br />
SELECT * from tblHistory WHERE TimeStamp = &quot;02/07/13&quot;<br />
<br />
But the recordset returns empty because the underlying data is ...<br />
<br />
TimeStamp<br />
02/07/2013 3:58:01 PM<br />
02/07/2013 3:58:15 PM<br />
02/07/2013 3:58:55 PM<br />
02/07/2013 3:59:01 PM<br />
02/07/2013 3:56:30 PM<br />
<br />
<br />
HELP?!
</div>
</div>


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 ...

TimeStamp
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


HELP?!

SQL query to pull today's transactions

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.