D
DeltaGamma
I have a simple table that records form values entered from a web page.
There is a date/time field with the default mm/dd/yy format. When data is
received via the web form all appears to go well, e.g. Nov 5 2004 ==>
11/5/04, as expected.
However, when manually entering data to the same table, entering Nov 5 2004
into the field results with 5/11/04. I have tried every premutation, and
every format control in design/data view etc, but the sill thing insists on
"reversing" Nov 5 to May 11th, when the data is entered manually (either
typed or copy/paste). Please advise.
There is a date/time field with the default mm/dd/yy format. When data is
received via the web form all appears to go well, e.g. Nov 5 2004 ==>
11/5/04, as expected.
However, when manually entering data to the same table, entering Nov 5 2004
into the field results with 5/11/04. I have tried every premutation, and
every format control in design/data view etc, but the sill thing insists on
"reversing" Nov 5 to May 11th, when the data is entered manually (either
typed or copy/paste). Please advise.