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.