Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    66

    Unanswered: access dates going in wrong

    I have an access db in uk format (dd/mm/yyyy)

    when i do

    update customers set sent=#11/10/2007# where ticketid='3245820'

    it goes into the db as 10/11/2007


    it's not happenaing with dates such as 16/10/2007 which are going in correctly?

    any ideas? hte only way to change is if i got to the records and manually switch.

    what could be causing this?

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    If you are defining the query in VBA then you need to ensure that all dates are formatted as American dates ie. mm/dd/yy; so literal string as above shoud be
    =#10/11/2007#
    for the 11th Oct
    and date variables (including the values of date controls) I suggest this

    = #" & Format(DateVariable, "mm/dd/yy") & "#"

    alway works for me !

    MTB
    Last edited by MikeTheBike; 11-05-07 at 08:42.

Posting Permissions

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