Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010

    Unanswered: Dates and Regions problem

    For some reason, access is storing the dates backwards when set to English-CA.

    If I set my pc to English-CA, and I have my vb application write #11/1/2010#, access stores it as jan 1 2010. If I change regional settings back to English-US, and have the app write #11/1/2010# access stores it as Nov 1 2010.

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    As answered elsewhere:

    In point of fact, Access always stores date/time values as a Double, where the integer represents the number of days since a given date and the decimal is the fractional time value. What you see is a formatting issue. In code, Access always expects the date in US format:;en-us;210069

    Date/Time: Return Dates in US #mm/dd/yyyy# format

    I use variation of the second link in applications that will be used outside the US.

Posting Permissions

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