Problem with dates format in views

[Gustavo_Armitan]

Hi, i have a problem with table appearance in the phone view. In google sheet and the pc view show the correct format (dd/mm/yy),but in the phone show diferent format(mm/dd/yy).

[Kirk_Masden]

Welcome to the community!

I like to use TEXT() to format dates in text columns. That way, I have complete control of how it looks:

help.appsheet.com

TEXT()

Format as text

Here’s a related tip:

CONCATENATING Dates Tips & Tricks 💡

To maintain your desired Date Formatting when concatenating dates, remember to enclose each date with TEXT() eg CONCATENATE(TEXT([DateCol1]), “and”,TEXT([DateCol2]))

[Gustavo_Armitan]

Thanks for your replied, but I don´t know where add this function TEXT() in my view or slice.
Sorry but I am new in appsheet.

[Kirk_Masden]

I’m not sure about what would be best for your situation but one method is to make a virtual column and put the TEXT() expression in that.

I remember when I was new to AppSheet and very confused about how to do these sorts of things. I think that there are good tutorials available for beginners now but I’m not sure which one to recommend. I hope someone else can help.

[Gustavo_Armitan]

Kirk, thank you so much for your help, I’m going to try a virtual column and continue learning about this great app.

[Steve · Accepted solution]

This problem is typically because your phone isn’t configured with your preferred locale, so you’re getting the representation used in the US.

[Gustavo_Armitan]

Thank you Steve, I resolved the problem with your help.