Bank Statement Import - Date Format Issue

(0) Share

Report

Posted on by Amanda Mayer

207

I am receiving the attached error when trying to Import a Bank Statement file (.csv) into Business Central. I've built the Data Exchange Definition and all related setups the same as my NAV 2017 install where it works, including the proper data format of M/d/yyyy with en-us. I cannot for the life of me get Business Central to recognize the date field correctly. Any thoughts?

Categories:

Other

Business Central

I have the same question (0)

All responses (12)

Answers (0)

rcboiler 1,204 on at

Like (0)

Report

I've had some success with M/dd/yyyy

Was this reply helpful? Yes No
Amanda Mayer 207 on at

Like (0)

Report

Unfortunately that change did not make a difference. It's strange that I'm getting some sort of leading characters on the date field.

Was this reply helpful? Yes No
Mich.serna 10 on at

Like (0)

Report

Hi! Did you ever get this resolved? I am having a similar error - also if the month is 11/1/2019, then it comes in as 1/1/2019, even if I have this set up as mm/d/yyyy, m/d/yyyy, m/d/yyyy - I have tried every combination and nothing comes in correctly.

Was this reply helpful? Yes No
rcboiler 1,204 on at

Like (0)

Report

Have you tried MM/dd/yyyy (not mm)?

Was this reply helpful? Yes No
tlhgolfer 23 on at

Like (0)

Report

Did you get this resolved I am having the same error and have tried every combination?

Thanks

Was this reply helpful? Yes No
Suggested answer

John Ray Patajo 837 on at

Like (0)

Report

The reason why mm/dd/yyyy does not work is that it can only read months 10,11,12, but for 1 to 9 it cant. I was able to successfully do it by using M/dd/yyyy format.

Was this reply helpful? Yes No
Jiggy Morgan 50 on at

Like (0)

Report

Go into the excel file and change the date to year - month - date (or match it to whatever date style you have in business central), then upload the file.

If you can't change the date in excel use this link to do so https://www.youtube.com/watch?v=Ya10z2gfRB8

it worked for me, hope it helps others.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

I have changed the bank statement import setup, not edit the Excel file as I don't what to have to edit each month.

Was this reply helpful? Yes No
JodeRuiter 982 User Group Leader on at

Like (0)

Report

This is obviously NOT the best solution, but I got an import to work that was failing on the date - no matter the format that I changed BC or the file to by simply moving the date field from the first column to the 2nd column.... weird.

Was this reply helpful? Yes No
Amanda Mayer 207 on at

Like (0)

Report

I did get this resolved, but I'll be honest I don't remember how or what customer it was to go find it.

Was this reply helpful? Yes No