When i import csv Bank statement file in NAV ,It imports dates with all the months as january.

Ooko

Hi
Kindly assist
In my data exchange definitions, i have setup a bank import as shown
General Tab


Field Mapping


Then finally columns


Now when I import the bank statement in csv into NAV, it imports the lines perfectly plus the amount but converts the months of all the lines to January. For example if the date of my bank statement line is 04/05/2017 (DD/MM/YYYY) the system populates 04/01/2017 same format but changes May to January.
What am I missing.

Yury

Hi,
Slawec suggests right solution, you should use capital letters.
Try dd/MM/yyyy

Slawek_Guzek

Hi,

Have you tried to change Date Format on columns definition to DD/MM/YYYY?

Slawek

Ooko

Yes I did but still converts the months to January but with the changed format

Yury

Hi,
Slawec suggests right solution, you should use capital letters.
Try dd/MM/yyyy

Ooko

Yury I have used that format and changed my data formating culture from en-US to en-GB an now it picks the right month. Thanks guys