mnongkhlaw
Programmer
I'm using Access 2000 with the input mask 00/00/0000;0;_ and short date format. British dates like 01/02/2003 (1st Feb, 2003)entered thru a web page's textbox bound to date/time field gets converted to 02/01/2003 in the table, but dates like 20/01/2003 (20th Jan, 2003) get stored correctly. My Regional Options (Win2000 server) settings :-
Locale : English (US) OR English (UK)
Short date format : dd/MM/yyyy
I found that entering 01/02/2003 directly into the Access table gets stored correctly. Then I just did a
Sub thisPage_onenter()
txtCustFrom.value=FormatDateTime(Date,vbShortDate)
End Sub
to find out whether my web page was the culprit, and sure enough, it displayed 10/23/2003 (American) instead of 23/10/2003 (British) in the txtCustFrom textbox bound to a date/time field.
How can I resolve it? I want to display and store dates in british format only.
Mark
Locale : English (US) OR English (UK)
Short date format : dd/MM/yyyy
I found that entering 01/02/2003 directly into the Access table gets stored correctly. Then I just did a
Sub thisPage_onenter()
txtCustFrom.value=FormatDateTime(Date,vbShortDate)
End Sub
to find out whether my web page was the culprit, and sure enough, it displayed 10/23/2003 (American) instead of 23/10/2003 (British) in the txtCustFrom textbox bound to a date/time field.
How can I resolve it? I want to display and store dates in british format only.
Mark