Date Format Problem
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 & "#"