I am Brazilian, date "12/01/2014" appears as "1/12/2014" when launched?

[clebergyn]

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?

[June7]

International date topic of a number of threads. Here is one https://www.accessforums.net/forms/i...-mm-40471.html

[Missinglinq]

Allen Browne, one of the foremost authorities on Access, resides 'down under,' where they use the dd/mm/yy date format, and has an excellent article on the subject:

International Dates in Access

Linq ;0)>

[clebergyn]

thanks very much! resolved!
format(data,"mm\/dd\/yyy")
was just right