Text([Date]) UK Format as opposed to USA
I need to construct a string using a date and although my Google sheet locale is set to UK as is my table in AppSheet it keeps returning USA format. How can I get UK format?
My Expression =CONCATENATE(TEXT([Date])," “,[PropertyShort],” ",[RoomOrBuildingElement])
My Result 10/22/2018 Furzehill Bed 5 (Guest Room)
The result I want to achieve 22/10/2018 Furzehill Bed 5 (Guest Room)