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

Ooko · 2017-09-20

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 · 2017-09-20

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

Slawek_Guzek · 2017-09-20

Hi,

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

Slawek

Ooko · 2017-09-20

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

Yury · 2017-09-20

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

Ooko · 2017-09-21

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

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

Best Answer

Answers

Categories