<div>
It is best to convert your date to a long date string before using it in the SQL statement. &nbsp;Eg.<br />
<br />
dim strDate as string<br />
<br />
strDate = format(text1.text, &quot;MMMM dd, yyyy&quot;)<br />
<br />
select * from ra where where start &lt;&nbsp;#&quot; &amp;&nbsp;strDate &amp;&nbsp;&quot;#&quot; <br />
<br />
<br />
This will convert &quot;01/06/2000&quot; to &quot;June 1, 2000&quot;<br />
<br />
<br />

</div>


It is best to convert your date to a long date string before using it in the SQL statement.  Eg.

dim strDate as string

strDate = format(text1.text, "MMMM dd, yyyy")

select * from ra where where start < #" & strDate & "#"


This will convert "01/06/2000" to "June 1, 2000"




<div>
what about the database that it is searching the values are in short date format
</div>


what about the database that it is searching the values are in short date format

<div>
It does work....<br />
<br />
if anyone is interested in the correct way to fix a date problem....look at this one......<br />
<br />
thanks very much<br />
<br />
where are you from......<br />
<br />
we also use dd/mm/yyyy
</div>


It does work....

if anyone is interested in the correct way to fix a date problem....look at this one......

thanks very much

where are you from......

we also use dd/mm/yyyy

<div>
I am from the country of Belize in Central America. &nbsp;It's a former British Colony therefore we use their date format.
</div>


I am from the country of Belize in Central America.  It's a former British Colony therefore we use their date format.

<div>
very interesting.....<br />
<br />
thanks for the help
</div>


very interesting.....

thanks for the help

<div>
<div class="content wysiwyg-content">
OK guys....<br />
<br />
i have a sql query that says<br />
<br />
&quot;select * from ra where where start &lt;&nbsp;#&quot; &amp;&nbsp;text1.text &amp;&nbsp;&quot;#&quot;<br />
<br />
now text1 is a date field.... i have tryied putting it to a dim and i have tried to use monthview as well but no matter how i do it does not recognise the date correctly...<br />
<br />
i want it to be dd/mm/yyyy and it just wants to see it as mm/dd/yyyy.<br />
<br />
any ideas...<br />
<br />
i am australian if you are wondering why
</div>
</div>


OK guys....

i have a sql query that says

"select * from ra where where start < #" & text1.text & "#"

now text1 is a date field.... i have tryied putting it to a dim and i have tried to use monthview as well but no matter how i do it does not recognise the date correctly...

i want it to be dd/mm/yyyy and it just wants to see it as mm/dd/yyyy.

any ideas...

i am australian if you are wondering why

BIG DATE PROBLEM

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.