Access and Dates

Results 1 to 3 of 3

Thread: Access and Dates

  1. #1
    Join Date
    Dec 1969

    Default Access and Dates

    I suspect that this is a common question, but I can&#039;t find anything on it in the FAQs.<BR><BR>I am based in the UK and have the locale settings for this country i.e. today&#039;s date = 06/08/02, and is displayed as such when I response.write it to the browser. However, when I go to insert the date into an Access db it ends up like this: 06/08/02. It is also displayed like this on the page once it has been extracted from the db.<BR><BR>Does anyone know whats causing Access to do this???<BR><BR>Cheers<BR><BR>Micheal

  2. #2
    Join Date
    Dec 1969

    Default ISO date format

    Use the ISO date format when inserting the date!<BR><BR>yyyy-mm-dd<BR><BR>and set <BR><BR>Session.LCID = 2057 in your Global.asa file, or on the first page of your site!<BR><BR>HTH.<BR>D.

  3. #3
    Join Date
    Dec 1969

    Default RE: Access and Dates

    Well,<BR><BR>read into the Session.LCID<BR><BR>I think there is a european setting for that....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts