Bank Statement Import

(1) Share

Report

Posted on by BK-23081314-0

I am having an issue while trying to import our bank statements. The date on the statements are in the following format:

01/08/2024, 08:41 UTC

I created a format dateTime format of:

<Day,2>/<Month,2>/<Year,4>, <Hours24,2>.<Minutes,2> <text>

I have tried using <comma> (for the comma after the date) and changing the length to 17 (to truncate the UTC and removing <text>) but nothing seems to work. I always get the following error:

Error message:
The file that you are trying to import, file.csv, is different from the specified Bank Statement Import, DATA_EXCHANGE_NAME.

The value in line 1, column 10 has incorrect format or type.
Expected format: Date, according to the Data Format and Data Formatting Culture of the Data Exch. Column Def.
Actual value: "01/08/2024, 08:41 UTC".

Thanks for any help!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Valentin Castravet 32,152 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

This worked for me, first, use a transformation rule to cut the time and UTC word, and then a 2nd transformation rule to convert the remaining value to a date format:

Second, in the data exchange definition, use the following settings:

This is what my bank rec. looks like:

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Kalu.Eke on at

Like (1)

Report
Copy link

Link copied!

Adding hours, minutes and timezone can be challenging but you can use these.

"<Day,2>/<Month,2>/<Year,4>, HH:mm 'UTC'" or "dd/MM/yyyy, HH:mm 'UTC'"

https://learn.microsoft.com/en-us/dotnet/api/system.globalization.datetimeformatinfo.rfc1123pattern?view=net-8.0

however, if do not need the hours and the minutes you can create a transformation rule for it.

https://learn.microsoft.com/en-us/dynamics365/business-central/across-how-to-set-up-data-exchange-definitions#transformation-rules

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, here is an example I tested before, I hope it can give you some hints as well.

https://yzhums.com/44582/

Thanks.

ZHU

Was this reply helpful? Yes No