User date format

(1) Share

Report

Posted on by tnaess

Hi all. We have a strange situation for one of our users in D365 Finance. The users preferences for language and date, time and number format are set to 'nb-no' and country/region is set to 'NOR'. This means that date format are 'dd.mm.yyyy' and for numbers spaces are used as thousands seperator and the decimal seperator is comma.

Suddenly, date and amount format on all forms in D365 Finance are on a different format, presumably 'en-us', meaning that dates are on format 'mm/dd/yyyy' and numbers have comma as thousands seperator and the decimal seperator is dot.

The same happens in both Chrome and Edge.

The regional and language settings on the users pc are set to Norwegian.

If another user logs in to D365F with their credentials on this users pc the everything works as expected meaning that the format from user preferences are being used. If the users logs on to D365F using Chrome Incognito mode, the date and number format works as expected meaning that the format from user preferences are being used.

We have been looking at the usage data to see if there is anything to delete but there is nothing that stands out. Has anyone experienced the same?

I have the same question (0)

All responses (15)

Answers (1)

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (1)

Report

Hi tnaess,

The regional settings on the PC are not influencing the date, time, and number format in Dynamics 365 F&O. Are the settings on the User options form still correct for the fields Language, and Date, time, and number format? The country field is also not relevant for the format on Dynamics 365 fields.

Was this reply helpful? Yes No
tnaess 25 on at

Like (0)

Report

Hi Andre. Thanks for your reply. Yes, the settings are all set to the correct values.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi tnaess,

I have never seen an issue before with this. Are you sure that this user has only one account and is using the correct one and the correct environment?

Are there probably linked accounts in Entra ID? Can there be a customization in your environment?

If all should be OK from your end, I would suggest logging an incident for Microsoft Support. Anyway, I'm interested to learn about the culprit.

Was this reply helpful? Yes No
Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report

Hi,

There are users on the forum who have encountered problems similar to yours before. Did you customize it? If not, you can refer to this old thread. It may be the settings in windows that cause this problem: Solved: date format (dynamics.com). Verify what region and locale is selected, and whether the user has customized the date format. Although the old thread was posted on the ax forum, I guess the same applies to FO.

Best regards,

Kevin

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (1)

Report

Kevin, it's not the same. AX 2012 a locally installed application, while F&O uses a web browsers instead. It's a very different topic.

Was this reply helpful? Yes No
tnaess 25 on at

Like (0)

Report

Hi all. Thanks for input. Yes, the user only have one account and is logging in to the correct environment. As mentioned it all works as it should when using Incognito mode. I'm guessing that resetting the user will do the trick, but then again the user loses a lot of settings. We might go to MS support with this issue then.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (1)

Report

Hi tnaess,

Apologies, I missed the fact that it is working in incognito mode for this user. In case this user uses another PC, is he then also having the same issue? It might be related to some, maybe corrupted, browser cache.

As you mentioned, maybe a ticket for Microsoft Support will be the way to continue.

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (2)

Report

Hi Tnaess,
We had almost the same issue for one user, and it was related to browser caching. Like Andre mentioned, I suggest deleting the browser cache to see if it helps

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,407 Super User 2025 Season 2 on at

Like (1)

Report

Hi @tnaess,

Had this strange issue in the past at a customer site. Later, found out that these settings are cascading from the Language and Regional settings in the Microsoft 365 section. The Microsoft 365 settings holds these details. It should be set to English (United States) by default. Most probably the settings for D365 FO are over-ridden from these Microsoft 365 settings. Hope this helps.

Happy to answer questions, if any.

Was this reply helpful? Yes No
tnaess 25 on at

Like (1)

Report

Hi all. We tried to delete cache, but still no change. Also looked at the settings in the Microsoft 365 section. Here the regional format was set to 'English (United States)'. It's also set to that value for my user, and my user have the correct date format according to the settings in D365F. Tried to change and logged on to D365F but there were no change. I guess there might be a slight delay due to sync. Will update the post with any findings we might have.

Was this reply helpful? Yes No