Date locale not being respected (I think!)

[gcor71]

Hi - I'm unable to see what's missing, anyone offer an insight?

I have a date which I want to include in a Display Name (see #1). 
I want it displayed in European / local date format (dd/mm/yyyy). 
I have set the date format in the Google Sheet source (#2) and in the AppSheet data table locale (#3). 
The data preview looks good (#4). 
However, in the app (#5) the locale settings isn't respected.

What am I overlooking?

1. Display Name formula in Dashboard view type: 
   "Report Run Date: "&SELECT(reporting[Run date],([Report]="-")
2. Data source is Google Sheet.
   
   • Locale = United Kingdom
   • Cell format = Date (dd/mm/yyyy)
3. Data > Table Settings > Localization in Appsheet set to ENGLISH (United Kingdom).
4. Preview Data in Appsheet - with expected date format.
   • 
5. 
   

[AleksiAlkio]

Use something like..

"Report Run Date: "&TEXT(ANY(SELECT(reporting[Run date],([Report]="-")),"dd/mm/yyyy")