With Access 2000...
I have a field set as a date/time with the format "d/m/yy" and when I enter "01 02 03", it reverses it to "03 02 01". anyone has an idea of what seems to be the problem?
Printable View
With Access 2000...
I have a field set as a date/time with the format "d/m/yy" and when I enter "01 02 03", it reverses it to "03 02 01". anyone has an idea of what seems to be the problem?
How are you putting it into the table ?
Sql is American - so the format must be in american format (if you use an sql statement to update the tables.
If you are using code, then its probably 'confused' over which month.
Best format for dates is : dd mmm yyyy (no confusion)
Vince
I put it in with my form, when I noticed the "error" I tried the Data sheet mode and it does the same thing