Date format change

I want to change the date format of my appsheet. 

08/01/2022 To 08 March 2022

Solved Solved
0 3 149
1 ACCEPTED SOLUTION

Aurelien
Google Developer Expert
Google Developer Expert
3 REPLIES 3

Aurelien
Google Developer Expert
Google Developer Expert

This ?

Aurelien_0-1649917292409.png

 

@Aurelien I activated this option in my app and it does show the date format as Oct 2, 2022 in the details view, however the date I put in my Google sheet still 10/2/2022, therefore when I create an HTML file using the date format, still shows 10/2/2022. Is there an easy way around it to make dates format input in Google sheets with other formats? 

Ok, I figured this one out. In the actual HTML you can write <p>&lt;&lt;Text([date column], "dd/mm/yyyy")&gt;&gt;</p> 

Top Labels in this Space