More about date format and other data formats

[cristinaclaverol]

I'm working with date format. It seems that Ode applies string format by option when it does not recognize the data format. Therefore, errors related to the data type are not detected: date in dd/mm/yyyy, latitude and longitude, currency format, etc. I include an example with the dataset and some screenshots. Since most datasets come from Excel tables, I consider it interesting to include the data formats it handles.
In the example I launch the dataset with dates in different formats and some inconsistencies within the 'final data' column in the ODE. ODE understands them all as strings and does not find any errors, it does not even recognize the column with numbers 'yyyy' as a year. I have performed several checks and I have seen that the dd/mm/yyyy format is not understood as a date and yyy-mm-dd is. So when I change the format of the 'final data' column in metadata from string to date, it finds the errors, but it is too complicated.

https://docs.google.com/spreadsheets/d/13CSLyU2z1xllFKfaY8pi5__szCNPJFPu/edit?usp=sharing&ouid=102377105873382543961&rtpof=true&sd=true