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)
Try with theโฆ CONCATENATE(DAY([Date]),"/",MONTH([Date]),"/",YEAR([Date])," โ,[PropertyShort],โ ",[RoomOrBuildingElement])
Just the job! Thanks Aleksi
User | Count |
---|---|
40 | |
36 | |
32 | |
23 | |
16 |