Text([Date]) UK Format as opposed to USA I n...

expressions
(StudentHomes Plymouth) #1

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)

(Aleksi Alkio) #2

Try with the… CONCATENATE(DAY([Date]),"/",MONTH([Date]),"/",YEAR([Date])," “,[PropertyShort],” ",[RoomOrBuildingElement])

(StudentHomes Plymouth) #3

Just the job! Thanks Aleksi