note
VSarkiss
<p>You probably have a copy-and-paste error, because even in Access that shouldn't run: you've got an unmatched single quote at the end. You probably meant this:<code>
SELECT * FROM TBLDATA WHERE ([Event Date] LIKE '8/08/2006*');
</code>
The question then is, what data type is <c>[Event Date]</c>? If you're storing the date as a string, then you need to match the string format exactly. Otherwise, if you're storing it as a date, you should be able to do it with the funny Access hash-quotes:<code>
SELECT * FROM TBLDATA WHERE ([Event Date] = #8/08/2006#);
</code>
If that doesn't work you may want to try canonical ODBC date format: <c>'2006-aug-08'</c>. It's hard to say without knowing more about the database and the code.</p>
<!-- Node text goes above. Div tags should contain sig only -->
<div class="pmsig"><div class="pmsig-72267">
<p><small><i>[id://149675|Do not rebuke them with harsh words ... but rather lead them gently - with URLs - so that they may learn wisdom.]</i></small></p>
</div></div>
578797
578797