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... Data Exchange Definiti...

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

Suggested Answer

Data Exchange Definition - Date format

(4) Share

Report

Report

Posted on by NI-V3

291

Hi,

We are in the process of creating a 'Data Exchange Definition' to import .csv files. But we face issue with date formats (as in some csv's the date was in MM/dd/yy others have dd/MM/yyyy and also like d/M/yyyy and dd/MM/yyyy)and temporarily we made a fix by setting date format in 'Data Exchange Definition' as M/d/yyyy and manually converted the csv's to this format and uploaded. Are there any standard date format to follow?

What we expect is that irrespective of any date format, Business Central should accept and alter it as needed..

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (0)

Sort by

Suggested answer

Khushbu Rajvi. 22,422 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hope this helps:https://yzhums.com/46834/

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,422 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Default format is based on the setting.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 16,481 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/across-how-to-set-up-data-exchange-definitions

https://learn.microsoft.com/en-us/dynamics365/business-central/ubb/masterdata/dataexchangedefinitions

https://learn.microsoft.com/en-us/dynamics365/business-central/ui-enter-date-ranges

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 100,919 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, The default date format is determined by the region setting of your account. You can try to change it first.

More details:

Entering dates and times in Business Central - Business Central | Microsoft Learn

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,555 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,

Its based on the base application.

https://learn.microsoft.com/en-us/dynamics365/business-central/ui-enter-date-ranges

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 26,761 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Date Formatting

Define how data is exchanged electronically - Business Central | Microsoft Learn

Best Regards
Gerardo

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,961 Super User 2026 Season 1

#2

YUN ZHU 1,211 Super User 2026 Season 1

#3

AndrewThomas81 1,141

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans