I cast the date 12/01/2014 in a table by an "append query" and appears 1/12/2014? why? already formatted in format and nothing, some other dates like 19/01/2014, this does not happen.
the date 01/19/2014 generates correct but the date 01/12/2014 generates wrong, generates inverted (01/12/2014)
use Access 2010
see the example codeCurrentDb.Execute "Delete * from datatemp"
function dt(d)
CurrentDb.Execute "INSERT INTO datatemp( dt ) SELECT #" & d & "# AS d4"
CurrentDb.Execute "INSERT INTO datatemp( dt ) SELECT #" & (d + 1) & "# AS d4" '
CurrentDb.Execute "INSERT INTO datatemp( dt ) SELECT #" & (d + 2) & "# AS d4"
end function
I need to be via vba code
where do I attach the file?