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?

[Grant_Stead]

Try wrapping the date in a text()

[Aleksi_Alkio]

As Grant mentioned, the CONCATENATE(TEXT([Date]), “INSERT OTHER TEXT HERE”) should work because the TEXT expression read the date value with the date format you are using in the app.

[Oliver_PT]

Hi all, brief update - tried this with no luck. Still getting the date in reverse order (ie mm/dd). Have tried wrapping the date in text(), and also tried creating a virtual column with the Text([Date]) field, but it is still pulling in the wrong format…! So bloody annoying

[Aleksi_Alkio]

And your sheet and all tables are using the same locale settings?

[Oliver_PT]

Will have to go through and check the back end when I get home. Though I have all of this happening in a field as an initial value formula as opposed to a sheet formula, and I can see the error happening live in the read only field with the CONCATANATE formula in it. This would all be happening on the appsheet end no? All the tables within appsheet are set to the same locale