Problems formatting a date

[Poppy]

I have the following at the top of my page :
Session.LCID = 2057 'UK
which sets local date/currency settings to UK.

But despite this, a date entered as "28/01/1999" and stored in Access as
"28/01/1999" is displayed as "01/28/1999".

I haven't a clue whats happening.
Any Ideas ?

[Bob Barrows [MVP]]

Poppy wrote:

I have the following at the top of my page :
Session.LCID = 2057 'UK
which sets local date/currency settings to UK.

But despite this, a date entered as "28/01/1999" and stored in Access
as "28/01/1999" is displayed as "01/28/1999".
Sigh.
Access does not store a date with any format. It stores a data as a number
of type Double. The whole number portion is the number of days since the
seed date. The decimal portion represents the time of day (.0 = midnight, .5
= noon)


I haven't a clue whats happening.
Any Ideas ?

Look up "date format" at www.aspfaq.com

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.