Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002

    Unanswered: Date stored as mm/dd/yyyy instead of dd/mm/yyyy

    Hi all,

    Whatever I try, I don't get my date in the correct way in my DB.
    I want to save the date when a record was added by using :

    strSQL = INSERT INTO .... VALUES ("#"  + CStr(Date) + "#")
    Suppose the current date is September 7, 2010
    then I want it in my DB as 07/09/2010 and NOT as 09/07/2010.

    Any idea how I can do that?

    Thanks in advance

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Allen Browne, an Aussie, has an excellent paper that explains the ins and outs of using non-USA date formats in Access:

    Microsoft Access tips: International Dates in Access

    Linq ;0)>
    Hope this helps!

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

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    ..actually Access/JET isn't storing your date as mm/dd/yyyy its storing it as DDDDDD.dddddd
    where DDDDDD is the number of days form an arbitrary point in time (IIRC its 01/01/1900) and the ddddddd is the decimal proportion of the day, so .5 is 12:00:00, .75 is 18:00:00

    the problem you are reporting is either a format issue on extracting the date OR as Linq suggests you are stuffing the data into the db in the incorrect form.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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