Issue with Date format I have a Date column ...

[Oliver_PT]

Issue with Date format

I have a Date column and am trying to pull the value accross in to a text string to form the unique ID.

I am doing so by using =CONCATENATE([Date], “INSERT OTHER TEXT HERE”). It works, however is changing the date format in the text string.

So the Date in the Date field shows correctly, ie DD/MM/YYYY, however it pulls it in to the text string as MM/DD/YYYY.

Any ideas?