I have a GoogleSheet that's been working fine using the
IMPORTXML function, until recently.
It seems that when the function imports XML data that are in ISO date and time format that it changes the format.
For example: importing "2021-12-20T00:00:00" becomes "12/20/2021 0:00:00"
Since the worksheet has been using the
MATCH function, the GoogleSheets imported value will not match the XML code's value.
How can this be resolved so that GoogleSheets imports and processes the data in "YYYY-MM-DDTHH:MM:SS" format as it did before?