<div>
The data in your table has a time component. So, you can't just compare it with date only. You need to truncate the time value from the data. The simplest way to do so is to use Date() function, like this:<br />
<br />
In the field write this expression:<br />
DateOnly: Date([YourTable].[yourColu<wbr />mn])<br />
In the criteria write your criteria:<br />
=#9/20/13#
</div>


The data in your table has a time component. So, you can't just compare it with date only. You need to truncate the time value from the data. The simplest way to do so is to use Date() function, like this:

In the field write this expression:
DateOnly: Date([YourTable].[yourColumn])
In the criteria write your criteria:
=#9/20/13#

<div>
try &nbsp;this criteria<br />
<br />
where datevalue([ServiceDateTime<wbr />])=#9/20/2<wbr />013#
</div>


try  this criteria

where datevalue([ServiceDateTime])=#9/20/2013#

<div>
Neither solution worked.<br />
<br />
The first said I had the wrong amount of arguments<br />
<br />
The second said data type mismatch<br />
<br />
Glen
</div>


Neither solution worked.

The first said I had the wrong amount of arguments

The second said data type mismatch

Glen

<div>
That worked.<br />
<br />
Thanks<br />
<br />
Glen
</div>


<div>
<div class="content wysiwyg-content">
I am writing a query in MS-Access using a SQL linked data table. &nbsp;The field, ServiceDateTime is a Date/Time format. &nbsp;When I look at the data it comes across as 9/20/13 8:52:00 AM.<br />
<br />
When I enter the criteria =#9/20/13# I get no data returned.<br />
<br />
How can transform the data to allow date criteria?<br />
<br />
Thanks<br />
<br />
Glen
</div>
</div>


I am writing a query in MS-Access using a SQL linked data table.  The field, ServiceDateTime is a Date/Time format.  When I look at the data it comes across as 9/20/13 8:52:00 AM.

When I enter the criteria =#9/20/13# I get no data returned.

How can transform the data to allow date criteria?

Thanks

Glen

Access Query on Date/Time not allowing criteria

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

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.