This is a multi-part message in MIME format.



------=_NextPart_000_0004_01C1A746.793377D0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: 8bit



Hi!



There are better ways. Use Session.LCID=2057



Have a look at this:

http://www.w3schools.com/asp/showasp.asp?filename=demo_lcid



Hakan

  -----Ursprungligt meddelande-----

  Från: Rade Popovic [mailto:poppublic@y...]

  Skickat: den 27 januari 2002 13:03

  Till: ASP Databases

  Ämne: [asp_databases] Re: Date format write from access





  The best way handling the date format is to do this.



   myDate = recordset.Fields("myDate")

  response.write Right("00" & Day(myDate),2) & "." & Right("00" &

Month(myDate),2) & "." & Year(myDate)

  '// this is dd.mm.yyyy. format,



  Rade Popovic







  ----- Original Message -----

  From: "Paul Cracknell" <paul.cracknell@b...>

  To: "ASP Databases" <asp_databases@p...>

  Sent: Sunday, January 27, 2002 9:58 AM

  Subject: [asp_databases] Date format write from access





  > I have a problem with a date written from a recordset, created from an

  > access table, being displayed in US format (mm/dd/yy). I must find a way

  > to display it in UK format (dd/mm/yy).

  >

  > The server and is configured to UK date settings and the format in ms

  > access is set to dd/mm/yy.

  >

  > I am guessing that this is a peculiarity of ADO but would really

  > appreciate some help in solving this. The strange thing is that if I use

  > the Date()function elsewhere, the date is written in UK format.

  >

  > Thanks

  >

  > Paul C




$subst('Email.Unsub'). ---



$subst('Email.Unsub').