<div>
You have to include the dates between #.<br />
<br />
Select * from db1 where mydate = #12/11/1998#<br />

</div>


You have to include the dates between #.

Select * from db1 where mydate = #12/11/1998#


<div>
Sorry Waty, I have tried that way and still not working.<br />
<br />
thanks<br />
<br />

</div>


Sorry Waty, I have tried that way and still not working.

thanks



<div>
Well, actually I hope there would be simpler way than that way. Anyway, thanks for the answer<br />

</div>


Well, actually I hope there would be simpler way than that way. Anyway, thanks for the answer


<div>
<div class="content wysiwyg-content">
Is there any way to 'select' all record with particular date value, without specifying the time value ?<br />
<br />
I have tried with the following command :<br />
<br />
Select * from db1 where mydate like &quot;12/11/1998&quot;<br />
<br />
but it always fails (no result return). I guess it's because I didn't use the complet date format, including the time portion.<br />
<br />
For examples : I want to list all records with date value &quot;1 january 98&quot;, how the sql statement should be ?
</div>
</div>


Is there any way to 'select' all record with particular date value, without specifying the time value ?

I have tried with the following command :

Select * from db1 where mydate like "12/11/1998"

but it always fails (no result return). I guess it's because I didn't use the complet date format, including the time portion.

For examples : I want to list all records with date value "1 january 98", how the sql statement should be ?

Set sql statement for Date

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.