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