web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Date Format for bank s...

Small and medium business | Business Central, N...

Suggested Answer

Date Format for bank statement import

(0) Share

Report

Report

Posted on by Sam_Yi

5

Hi there,

I'm importing a bank statement where the date format is 2022-12-01T08:16:41.689735-05:00

What's the correct date format to use in the Bank Statement File Setup? I've tried several different ones but none of them seemed to work.

For example:

yyyy-MM-dd HH:mm:ss.SSSSSS

yyyy-MM-dd HH:mm:ss.SSSSSS-Z

Is there a way to make this happen without manually change the date to a more simple format?

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

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

Like (0)

Report
Copy link

Link copied!

Hi, I'm sorry that I haven't tested it in detail, but it may only be Date format here, not DateTime, so it may only support something like yyyy-MM-dd.

Specifies the format used for dates in the bank statement file. Note that the Microsoft standard date and time format requires capitalization for the month, for example, dd/MM/yyyy or d-M-y.

Hopefully other experts can give you better advice.

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,949 Super User 2026 Season 1

#2

YUN ZHU 1,064 Super User 2026 Season 1

#3

Khushbu Rajvi. 559 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans