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

OokoOoko Member Posts: 17
Hi
Kindly assist
In my data exchange definitions, i have setup a bank import as shown
General Tab
rlg1k3r0j1u0.png

Field Mapping
wg1o5pb1axi1.png

Then finally columns
0w428hnee1b6.png

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

Answers

  • Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    Hi,

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

    Slawek
    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: 17
    Yes I did but still converts the months to January but with the changed format
  • OokoOoko Member Posts: 17
    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.