Change Date format to dd/mm/yyyy of Date type Virtual Column

[nemus]

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.

[Aurelien · Accepted solution]

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

[nemus]

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