Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2011
    Posts
    4

    Unanswered: Help please: Access

    My computer & cell says it is 05/07/2012 and is Thursday

    but in access 05/07/2012 is Friday

    what is wrong

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Depends where ya are. If you're in America, 05/07 means May 7 which was, incidentally, a Monday, not Friday. If you're in some European countries, 05/07 means July 5, Thursday. You can reset your calendar in Access to have the European format also, if you wish.

    Sam

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Access is very USA-centric, and since you appear to be 'Across-the-Pond,' here's an article by the "Wonder-from-Down Under," Allen Browne, on working with International Date Formats:

    Microsoft Access tips: International Dates in Access

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Dec 2011
    Posts
    4
    Thanks Sam

    I found if i do it this way it works, dont know why
    Day: Weekday([DateStart],2)

Posting Permissions

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