Hi as subject as I am having difficulty in creating an expression for it. This is what I have tried so far,
DATE(TEXT(“12/27/2021”,“dd/mm/yyyy”)) but it does not return anything.
Hi @nemus
You may want to consider changing the locale of your table datasource and table in your app editor, and check the locale on your device.
Please note that generally, AppSheet will consider date processing with US format, i.e mm/dd/yyyy.
This:
DATE(TEXT("12/27/2021","dd/mm/yyyy"))
Won’t work. But you might want to consider, for displaying purpose, using instead:
TEXT(DATE("27/12/2021"),"dd/mm/yyyy"))
or
TEXT([date],"dd/mm/yyyy")
or
TEXT([date],"dddd dd mmmm yyyy")
(depending on the result expected).
Basically, no need to change anything as long as you use in your expression the mm/dd/yyyy formatting.
For further reference:
Search - Google Cloud Community
Solved: Date Format - Google Cloud Community
Date and time expressions - AppSheet Help
1 Like
My Bad, I realised the column I needed to change was just a normal text virtual column, so I just used use the Text() method. Thank you
2 Likes