For some reason I can’t format a Date field that I’m showing on a detail view.
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?