date format on entity forms

[werner1]

Hi All

I'm having difficulty on dealing with the date format on forms.

I have changed the current format to English (New Zealand)  to show dates as dd/mm/yyyy both on Settings/Personal Options on the Portal Management and on Settings/Administration/System Settings, but the form that I have in a page of the portal (to be used by an invited contact) still shows dates in mm/dd/yyyy. 

Do I need to recreate the entity or the form for the new format to take effect? or is there somewhere else I need to change the setting?

Any help is much appreciated.

Regards

Werner

[v-monli-msft]

Hi @werner1 ,

In Form control, you can set below formula on the control to show the date format in dd/mm/yyyy format:

Text(Now(),"dd/mm/yyyy")

And the format goes with the locale setting of your computer. For more information, please refer to:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/show-text-dates-times

Regards,

Mona

[werner1]

Hi Mona
I guess that's for a canvas-app. I can't see anywhere I can change the control format when using an entity form. I have created a new CDS entity,  the testDate field is of type Date only. I have created a custom form for that entity and used that form on a page from the portal. Picture on the left shows part of the form definition and on the right the page displaying on browser.   

Regards

Werner

[dileeps · Accepted solution]

This documentation explains how the datetime field behaves on portal and how you can make date field appear in the format you want https://docs.microsoft.com/en-us/powerapps/maker/portals/configure/behavior-format-date-time-field

[werner1]

Although I have read that article several times, it was not clear to me that i needed to add a site setting DateTime/DateFormat, even if there is another place to set date format (system settings for Dynamics 365).

Thanks for helping solve the problem.

[dileeps]

Np @werner1 , would you mind marking the thread as answered

[tacklers2]

Great post.

Any idea of what the syntax of the site setting actually is?

Cheers, Richard

[MichaelGartner]

For anyone who finds this in the future, this worked for me:

1. yyyy-MM-dd – 2020-05-16

2. MMM dd yy – May 13 20

3. dd/MM/yyyy – 27/05/2020

4. dd/MM/yyyy HH:mm – 14/05/2020 12:27

5. dd/MM/yyyy hh:mm:ss – 12/05/2020 12:30:52 – 12 Hour format

6. dd/MM/yyyy HH:mm:ss – 27/05/2020 19:32:02 -24 Hour format

From: https://debajmecrm.com/working-with-custom-datetime-formats-in-powerapps-dynamics-365-portals/