55
M

Date format on report layouts (Canadian and other non-U.S. settings)

Marie-Soleil Goulet-Sawka on 3/11/2020 9:18:51 PM
Using the standard Business Central report layouts and the English (Canada) or French (Canada) region as well as some European region settings results in an odd date format on printouts. For example, "July 21, 2018" will be displayed as "2018 July 21."

The displayed date with Canadian settings corresponds to the YYYY-MM-DD standard numerical format but as a long date format is displayed, there is an issue and the readily available custom layouts cannot be used because the date format is not a valid date format.

The solution would either be to stick with the numerical format (YYYY-MM-DD in English and DD-MM-YYYY in French) or to display the correct long format on the custom layouts.

The current workaround of using English (United States) settings is not viable for non-English users. The other workaround is to create new layouts by modifying the date format on the fields, which defeats the purpose of having readily available templates that should be easily personalized by key users.

Category: Reports and Business Intelligence
STATUS DETAILS
Planned
2021 Release Wave 1
Ideas Administrator

Business Central Team (administrator)

Thank you for your valuable feedback. We are delivering updated date formatting in the next major release, Business Central 2021 Wave 1. Furthermore, we plan to roll this out in a minor update to the current release.

Your help is greatly appreciated
Jens Møller-Pedersen
Engineering Manager, Microsoft  

Comments

M

M

RE: Date format on report layouts (Canadian and other non-U.S. settings)

Andrew Kwa on 10/25/2021 2:33:53 PM

Is there an update for this? It was Planned for Wave 1 this year but doesn't appear to have been delivered?

Category: Reports and Business Intelligence

M

M

RE: Date format on report layouts (Canadian and other non-U.S. settings)

Eelco Wijrdeman on 4/6/2020 6:10:56 AM

In the Dutch localisation the date format which is used in the reports is 10 March 2018. Our customers like to see this in 10-03-2048

Category: Reports and Business Intelligence

M

M

RE: Date format on report layouts (Canadian and other non-U.S. settings)

Nicolas Saleron on 3/28/2020 10:47:37 AM

In France, the annoying thing on reports is the dot after the day.
In standard report, March 10th, 2020 is displayed 10. mars 2020. It is a small, very small thing, but customers complain about this little dot after the Day.
We have to create à layout or sometimes duplicate the report just for that kind of small things.

Please note this problem exists for decades in NAV...

Category: Reports and Business Intelligence

M

M

RE: Date format on report layouts (Canadian and other non-U.S. settings)

Marie-Soleil Goulet-Sawka on 3/12/2020 9:11:45 PM

This Idea is related. https://experience.dynamics.com/ideas/idea/?ideaid=a4bd480b-ace9-e911-b862-0003ff68bfb4
The date format also causes issues with electronic funds transfers (EFT).

Category: Reports and Business Intelligence