To maintain your desired Date Formatting when concatenating dates, remember to enclose each date with TEXT() eg
CONCATENATE(TEXT([DateCol1]), โandโ,TEXT([DateCol2]))
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