Trouble formatting a date field

IAR
New Member

Hey there,

For some reason I can’t format a Date field that I’m showing on a detail view.

Some background:
The Google sheet locale is set to Portuguese. In Google sheets, I can see the inserted dates appear in the desired format (DD/MM/YYYY).
In Appsheet editor, the Data table locale is set to the same language. In the app preview, the date itself also shows correctly as DD/MM/YYYY.

But, when opening the web app, the Date is showing as MM/DD/YYYY, which is not what I want.
I checked on three different devices and all show it like that.

I’ve tried using TEXT in different ways, without success. I suspect I am not applying it the right way. Can you help?

I’m currently using DD-MMM-YYYY on the formula:

TEXT([Updated on], “dd-mmm-yyyy”)

When testing the expression, it actually looks good.

But even this is ignored on the app preview (which still shows DD/MM/YYYY). And the resulting web app still shows MM/DD/YYYY

How can I solve this?

0 3 167
  • UX
3 REPLIES 3
Top Labels in this Space