Weird problem of storing the data format

[rick]

I am using MS Access as my data source. The date field
was originally set to dd/mm/yyyy format and the server of
regional setting as well. Recently I have changed both
date format to dd/mm/yyyy. When I try to input the data
using adodb.recordset, it still store the data fomrat to
mm/dd/yyyy. Pleae help !

[Bob Barrows]

rick wrote:

> I am using MS Access as my data source. The date field
> was originally set to dd/mm/yyyy format and the server of
> regional setting as well. Recently I have changed both
> date format to dd/mm/yyyy. When I try to input the data
> using adodb.recordset, it still store the data fomrat to
> mm/dd/yyyy. Pleae help !

Access does not store dates with any format. The Format setting only affects
how the dates are displayed.

Dates are stored as Doubles, with the whole number portion reflecting the
number of days since a seed date, and the decimal portion reflecting the
time of day (.5 = noon). All formatting is done by the client application.

[url]http://www.aspfaq.com/show.asp?id=2260[/url]

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.