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

OokoOoko Member Posts: 16
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.

Best Answer


  • Slawek_GuzekSlawek_Guzek Member Posts: 1,688

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

    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • OokoOoko Member Posts: 16
    Yes I did but still converts the months to January but with the changed format
  • OokoOoko Member Posts: 16
    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
Sign In or Register to comment.