Access Date Problem

Results 1 to 2 of 2

Thread: Access Date Problem

  1. #1
    Join Date
    Dec 1969

    Default Access Date Problem

    I have a bit of a puzzle going on with Access and dates<BR><BR>I have an ASP page that is inserting the date into the db i.e. #07/05/02# (this is working no problem) However, when I look inside the db, Access has swapped the date round to 05/07/02.<BR><BR>I have checked my control panel and the regional settings are setup correctly for the UK. My ASP page returns the date in the correct UK format.<BR><BR>So does anyone know why Access is doing this. I realise that if it&#039;s not broken don&#039;t fix it blah..blah, but I would really like to know whats causing it, just in case it creates problems in the future.<BR><BR>Thanks<BR>Micheal

  2. #2
    Join Date
    Dec 1969

    Default RE: Access Date Problem

    There&#039;s a FAQ all about Dates - you might want to find that and read it.<BR><BR>The is linked to at the top of almost every page of the aspmessageboard.

Posting Permissions

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