Hello, I need help changing date displayed from DD/MM/YYYY to DD/month/YYYY
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
can the above formula be modified to display the weekday (Mon…Tue…etc) as well? End result would be Mon 11-Mar ?
TEXT(TODAY(), "ddd d-mmm")
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!!