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

[StudentHomes_Pl]

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]

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

[StudentHomes_Pl]

Just the job! Thanks Aleksi