Microsoft Articles

Change date format to DD-MM-YYYY in a Canvas App

I live in Australia.  One of the first things I do (right after removing the word “Zip” from the postcode field!) in a new Dynamics 365 demo is to change the date format to DD-MM-YYYY instead of the US date format MM-DD-YYYY.  It’s a little thing, but often it’s the little things that can make a big difference.  If you’re in one of the many countries in the world that doesn’t use US date format, working with a business system that shows the date in the wrong format is just annoying.  Putting it in front of a customer feels jarring.

So, when I came do to my first PowerApps (Canvas App) demo for a customer here that involved showing a date field, I *had* to work out how to get rid of that pesky US date format.  It took a bit of Googling around and experimenting, but it turns out a simple formula will do the job.  I have this one readily available for copy-paste every time I create a PowerApp now, so I hope this will make things easier for those of you also outside the US.

The magic formula:

Text(ThisItem.’Est. Close Date’,”[$-en-US]dd/mm/yyy”,”en-GB”)

(I’ve used the Opportunity Estimated Close Date here as an example – simply substitute the name of your actual date field in place of “Est. Close Date” in this formula).

Bingo.  Happiness.

 

 

952
lisacrosbie

0

lisacrosbie


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.