My Regional Settings are English (United Kingdom) with short dates set to dd/mm/yy and long dates set to dd mmmm yy.
In code, when I execute an SQL with a WHERE MyDate = #09/10/00# (the English format dd/mm/yy) is seems to believe that I am using the American format (mm/dd/yy). Is there a setting somewhere in Access/SQL which will force treating of these dates as English ?
Querying in native MSACCESS, dates are treated as I expect ... as English. Although if I switch to SQL mode, I notice that the Access Query has strangely switched the day and month around into mm/dd/yy format to make it work. It's almost as if I have to submit SQL queries using dates in American (mm/dd/yy) format.
Martin.
In code, when I execute an SQL with a WHERE MyDate = #09/10/00# (the English format dd/mm/yy) is seems to believe that I am using the American format (mm/dd/yy). Is there a setting somewhere in Access/SQL which will force treating of these dates as English ?
Querying in native MSACCESS, dates are treated as I expect ... as English. Although if I switch to SQL mode, I notice that the Access Query has strangely switched the day and month around into mm/dd/yy format to make it work. It's almost as if I have to submit SQL queries using dates in American (mm/dd/yy) format.
Martin.
