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

Data Exchange Definition - Date format

(4) Share

Report

Posted on by NI-V3

188

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

All responses (6)

Answers (0)

Gerardo Rentería Ga... 19,169 Most Valuable Professional on at

Like (2)

Report

Data Exchange Definition - Date format

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
Suggested answer

Ramesh Kumar 4,514 on at

Like (2)

Report

Data Exchange Definition - Date format

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.
Suggested answer

YUN ZHU 83,305 Super User 2025 Season 1 on at

Like (2)

Report

Data Exchange Definition - Date format

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
Suggested answer

Jainam M. Kothari 7,938 on at

Like (2)

Report

Data Exchange Definition - Date format

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
Suggested answer

Khushbu Rajvi. 16,497 Super User 2025 Season 1 on at

Like (3)

Report

Data Exchange Definition - Date format

Default format is based on the setting.
Suggested answer

Khushbu Rajvi. 16,497 Super User 2025 Season 1 on at

Like (3)

Report

Data Exchange Definition - Date format

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