Problem with italian dates localization Appsheet and Google Sheet

[Antonino]

Hi everyone, unfortunately I am not able to agree Google sheets with Appsheet regarding the dates in extended format in order to then be able to correctly filter the dates on the sheet A-Z or Z-A, let me explain.

Both Google Sheets and Appsheet are localized in Italian but as you can see from the last image, the filter function cannot correctly sort the dates from the most recent to the oldest.

Appsheet italian

Google sheet italian

Data validation: invalid value

Wrong dates sort

Unfortunately Appsheet localized in Italian, writes the date as DD/MM/YYYY HH: MM: SS

Google Sheets localized in Italian instead wants the dates as DD/MM/YYYY HH.MM.SS

The data validation (Check: Data = "is a valid date") gives me "wrong value" and consequently the Z-A or A-Z filter does not work, if instead I manually write the date in the format DD/MM/YYYY HH.MM.SS, the validation data is successful and the filter works correctly.

I found a trick, set the Google sheet in English (united kingdom) but I'd like to solve with the Italian localization (Italy)

Sort ok

It was a bit long post I hope I explained myself well, thanks for your patience and thanks to the whole comunity.