Date format in DRW query
Posted on 2003-11-06
I have a form which displays results based on 2 dates, DateFrom and DateTo.
However the form or server doesn't handle the dates correctly. Despite everthing being set up regionally correctly (UK) and hence dd/mm/yyyy, the dates are taken as mm/dd/yyyy.
How can I correct this so the query handles the dates correctly? The date part of my query is simply..
WHERE (tblDefect.DateClosed BETWEEN #::DateFrom::# And #::DateTo::#)
I've found that, the problem occurs dependant on the date entered.
All dates are entered as dd/mm/yyyy format.
Enter 01/10/2003 - This is taken as 10-January-2003 (should be Oct 1st)
Enter 15/10/2003 - This is taken as 15-Octover-2003 (correct)
Strange or what!
Please help me!