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 31,575 Super User 2025 Season 2 on at

Like (2)

Report

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

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 95,763 Super User 2025 Season 2 on at

Like (0)

Report

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