ShortDate format result not what I am expecting

[365-Assist]

I am looking to format my date as “m/d/yyyy” or "d/m/yyyy". However, I want my app to be used internationally and do not want to hard code the date format. So I thought I would try the ShortDate Format. However it results in a format I do not want. "MMM dd, yyyy".

I argue that this int a Short Date and in fact this is not how Short Date works in Excel.

Anyone have any thoughts on how I can achieve a true short date without hard coding?

[Drrickryp]

@365-Assist 

There are other ways to use Text() to enforce formatting if ShortDate isn't what you want.   For example:

In all my observations, @Meneghino , knows best about working with dates.  Here is one of his references for international date issues.   https://powerusers.microsoft.com/t5/Building-Power-Apps/Best-DATE-format-for-INTERNATIONAL-app-use/t... 

Text(Today(),ShortDate,Language()) will format the date according to the Language of the user's browser. In my case:  

[timl · Accepted solution]

@365-Assist 

I agree that what you see is not a 'short date'.

For me, ShortDate returns the format that I would expect.

I'd be interested to find out why ShortDate produces the format "MMM dd, yyyy" for you. If you try a different browser on the same computer, does your formula still output a value in "MMM dd, yyyy" format? Also, in Windows control panel > Region, is your Short date format set correctly?

[365-Assist]

Bravo @timl . You are correct it is set by the browser language. Australia shortdate format setting seems to be a bug in Power Apps.

I tried it in Chrome and Edge with same result.