Unanswered

How to change Date column format in Dataverse from MM/DD/YYYY to dd.MM.yyyy?

(0) Share

Report

Posted on by ultrAslan

100

I have searched for a long time but unfortunately found a working solution for me. It is very inconvenient that this option is not offered directly.

What I already did is:

In the legacy Admin area, going to the "Advanced Settings" area, navigating to "Settings" | "Administration" | "System Settings" | "Formats" and choosing the format (Germany) what I need. So dd.MM.yyyy.

But after this; in Dataverse it's still in format MM/DD/YYYY.

If you could tell me where the format can be specified, that would be a great help!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

Hi @ultrAslan,

Changing the format in the system settings sets a default for new users going forward, but does not apply to existing users. A user's personal settings override the default system settings.

The steps to update your personal options/settings are documented here.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
ultrAslan 100 on at

Like (0)

Report

Thank you but unfortunately the solution you've given is for model-driven Apps but I am working on a Canvas App with Dataverse as datasource.

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@ultrAslan

If you're trying to format the date retuned from dataverse in a canvas app you can do something similar to the below:

Text(ThisItem.Date,”dd/mm/yy”)

Was this reply helpful? Yes No