HELP! change date format!

Hello, I need help changing date displayed from DD/MM/YYYY to DD/month/YYYY

1 Like

Thx but I still don’t get it could you provide a step by step guide please. I would like the app to read the date as 03-Mars-2020.

TEXT(TODAY(),“dd-mmmm-yyyy”) will give you 11-March-2020 and TEXT(TODAY(),“dd-mmm-yyyy”) will be 11-Mar-2020

2 Likes

can the above formula be modified to display the weekday (Mon…Tue…etc) as well? End result would be Mon 11-Mar ?

Try:

TEXT(TODAY(), "ddd d-mmm")

See also:

3 Likes

Thank you, this worked. TEXT is so much easier than the previous way of converting Dates/Time! Thank you for continuing to provide help and making AppSheets better and better!!

2 Likes