Problem with date in ms access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Jozo
    New Member
    • Sep 2008
    • 6

    Problem with date in ms access

    Dear All,

    This is my first time on this site and I am very happy!
    I have problem regarding to date (new or old ms access document)
    My problem is that access changes date after 09/11 to 11/09 i don't know why!
    I tried to change default date in windows but after that I have also problem with date!

    Please help me!

    If you have any questions, don't hesitate to contact me!

    Rgds,
    Jozo
  • missinglinq
    Recognized Expert Specialist
    • Nov 2006
    • 3533

    #2
    Sounds like you're using a date format other than that used in the US. Allen Browne has an excellent article that explains this as well as workarounds on his site found here:

    How to ensure dates are interpreted correctly in a Microsoft Access database, even when the user's regional settings are different from the US format.


    Welcome to Bytes!

    Linq ;0)>

    Comment

    • Jozo
      New Member
      • Sep 2008
      • 6

      #3
      Dear...
      Yes, that is my problem.
      10 days ago I installed original windows XP professional and yesterday after that I remark that I have problem with date in ms access.
      Thank you very much for your suggestion!

      Rgds,
      Jozo

      Comment

      • missinglinq
        Recognized Expert Specialist
        • Nov 2006
        • 3533

        #4
        Glad we could help!

        Linq ;0)>

        Comment

        Working...