CONCATENATING Dates

Lynn
Participant V

To maintain your desired Date Formatting when concatenating dates, remember to enclose each date with TEXT() eg
CONCATENATE(TEXT([DateCol1]), “and”,TEXT([DateCol2]))

10 5 1,679
5 REPLIES 5

This is a good one, thanks @Lynn

Will this keep the dates in the localized format? ether MMDDYYYY or DDMMYYYY?

Passing a Date value through TEXT() will apply the current locale’s date format to the output, yes.

Thanks, Steve.

noob here, my google sheet locale is italian but I alway use my software in english.
nonetheless the date is displayed in uk format DD/MM/YYYY.
When appsheet reads it it becomes MM/DD/YYYY. I’m not nitpicking but the work I do with my app is preciesely to go trough boxes named with the date, written in DD/MM format so having to read it everytime in the other way gets very tedious. Is there a way to “force” the locale on appsheet ?
I’m working on a virtual column with the date displayed as text using LEFT, RIGHT, TRIM etc but I can’t believe there’s no way to get the proper DD/MM values in other ways

thanks

EDIT: looks like pasting again the data into the sheet made appsheet read the date value within the right locale, no need to create a text virtual column so

Top Labels in this Space