Access Database Date Problem

Results 1 to 2 of 2

Thread: Access Database Date Problem

  1. #1
    Join Date
    Dec 1969

    Default Access Database Date Problem

    Dear Expert<BR>I am facing a big problem in Access db.I am using ASP and Access DB.But the problem is Access storing Date as yy/mm/dd format though the format is shortdate or general date and when I display it using ASP, it shows in strange format something like 04/09/2025 though it should be 25/09/04.My regional setting is dd/mm/yy and at ASP i tried almost all Date Format like vbShortDate,GeneralDate and even some customize routine.Can u expert give me a relaxation for this?

  2. #2
    Join Date
    Dec 1969

    Default RE: Access Database Date Problem

    Access you should set your date to a four year as in<BR><BR>DD/MM/YYYY

Posting Permissions

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