I am using FoxPro database. I have used british format date. When I have used the query for retrieving data from specific range sometime it gives result. Sometime it does not gives any result.

The problem is if I enter 15/10/2006 it recognizes that the first value is date, second is month. If I enter 11/05/2006,this situation it takes 11 as month and 5 as date. Help to solve this problem.

The FORM input value is stored as:
dtF = trim(Request.Form("dtFrom"))

The Query string is:
SELECT * FROM ISSUE WHERE IDATE >= #" & dtF & "#"

Can you post the code for your form?

=======================
Strange and crazy, but everything is possible

The form code to accept date is:
<INPUT Type="Text" Name="dtFrom" Size="10">