Results 1 to 3 of 3

Thread: Problem with dates

  1. Oct 8th, 2002, 08:52 AM #1
    lpgodin123
    lpgodin123 is offline

    Thread Starter
    Member
    Join Date
    Sep 2002
    Posts
    43

    Question Problem with dates

    With Access 2000...

    I have a field set as a date/time with the format "d/m/yy" and when I enter "01 02 03", it reverses it to "03 02 01". anyone has an idea of what seems to be the problem?
    Reply With Quote Reply With Quote
  2. Oct 8th, 2002, 08:56 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343
    How are you putting it into the table ?

    Sql is American - so the format must be in american format (if you use an sql statement to update the tables.
    If you are using code, then its probably 'confused' over which month.

    Best format for dates is : dd mmm yyyy (no confusion)


    Vince

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  3. Oct 8th, 2002, 09:00 AM #3
    lpgodin123
    lpgodin123 is offline

    Thread Starter
    Member
    Join Date
    Sep 2002
    Posts
    43
    I put it in with my form, when I noticed the "error" I tried the Data sheet mode and it does the same thing
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width