R
richardhowell
Guest
I guess this question has been raised many times, even though I have searched the forum for an answer, but without success.
OK - I'm in the UK, and I like my dates to be DDMMYY, and not MMDDYY. My input form (Dreamweaver/Ultradev 4) manages to validate the input in the format dd/mm/yyyy before sending off to update Access 2000 database.
My date column in Access, Format - Date, is Shortdate with an example of 19/06/1994 being displayed (ie. in UK format).
So - why does Access, on receipt of inputted data, immediately convert this into 06/19/1994 format? And of course when retrieving the date back in dreamweaver, it displays in this same format.
I'd like a workaround please!
Richard
OK - I'm in the UK, and I like my dates to be DDMMYY, and not MMDDYY. My input form (Dreamweaver/Ultradev 4) manages to validate the input in the format dd/mm/yyyy before sending off to update Access 2000 database.
My date column in Access, Format - Date, is Shortdate with an example of 19/06/1994 being displayed (ie. in UK format).
So - why does Access, on receipt of inputted data, immediately convert this into 06/19/1994 format? And of course when retrieving the date back in dreamweaver, it displays in this same format.
I'd like a workaround please!
Richard