S_A
Posts: 29
|
| Posted: 02/07/2005, 4:22 AM |
|
I have a problem with dates being written to my access database in US format - mm/dd/yyyy - I need them in UK format dd/mm/yyyy.
This happens with two fields I have, one is set to 'Current Date' as the default value, and the other you can use the date picker or simply type the date in.
Of course this only happens if the day (dd) is less than 13, as you clearly can't have 13 months!
The database table has the date fields set to dd/mm/yyy
The LCID in Common.asp is set to '&H809' (not sure what the 'H' bit is) but 809 is the right code I believe for the UK.
In the project properties, form fields and server connection the date display formats are all set to dd/mm/yyyy.
On the server (Win2k) , the 'Regional Options' are set to UK format.
If I go to a DOS prompt and type 'Date' I get it in dd/mm/yyyy format.
If I create a form in access to write to the same table it works....
I have checked everything I can think of many times over, does anyone have any suggestions please?
Thanks,
Scott.
|
 |
 |
peterr
Posts: 5971
|
| Posted: 02/07/2005, 11:33 AM |
|
Scott,
Looks like the format "dd/mm/yyyy" for the Server connection is wrong and cannot be used there. Databases usually don't use such format for storing dates internally. I think that everyone uses the default date format that CCS sets automatically when you select MS Access there. There is no difference between countries, because MS Access probably always internally stores all dates in one format. I don't think that this can be changed, thus you cannot decide on which format to use. You can only specify which format your database already uses.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
