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).