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

Data Exchange Definition - Date format

(4) Share

Report

Posted on by NI-V3

268

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 (6)

Answers (0)

Suggested answer

Khushbu Rajvi. 20,601 Super User 2025 Season 2 on at

Like (3)

Report

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

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,601 Super User 2025 Season 2 on at

Like (3)

Report

Default format is based on the setting.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (2)

Report

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

Like (2)

Report

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

Like (2)

Report

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... 25,236 Most Valuable Professional on at

Like (2)

Report

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