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