Date format when used with CONCATENATE

[Phil_Waite]

Hi,

I have a date column that works fine. It is formatted dd/mm/yyyy.

When I CONCATENATE the date column with other columns it reverts to mm/dd/yyyy. (I am in the UK)

I can use CONCATENATE(TEXT([Date] etc which I have used before to get the right format but I am using the CONCATENATED column in the “group by” function and with the TEXT funstion the order is ot according to the date.

Below is a pic of the correct order but wrong date format

Below is the correct format but wrong order

Thanks

Phil