Conversion date

[ChristopherL]

Hiho!
Looking for a solution for this problem for microsoft Access!

When I am importing a date value it mixes up the year/month/day value and enters the year as date and the day as the year.
Anyone know the conversation for this?

I've tried with
CorrDate: Format([REPORT_DATE];"yyyy/mm/dd") but this only gives me the same thing back..
The date that I am trying to import is 2013-07-02 but it gives me 2002-07-13 :/​

 

[CJ_London]

you are using a semi colon in your format fucntion - it should be a comma