opendataeditor
opendataeditor copied to clipboard
Date format changed at xlsx
Overview
-I upload a file in xlsx
OPEN DATA EDITOR-Plans estrateÌgics Barcelona Eixos-ODS modificado con info.xlsx
-and the same as url
https://docs.google.com/spreadsheets/d/1tcLbrMGDEdWQzxyLJoq4zb20OSC6nWi-/edit?pli=1&gid=368550936#gid=368550936
-In the xlsx file ODE detects an error in the date. The original file has the logical date format in spanish: 1/1/2030 (day/month/year).
-I go to ERRORS REPORT and I see that it has changed the date format to year/month and has also added time, which is not in the original format.
- I go to the metadata/ SCHEMA/FIELDS and I notice that in the field it identifies it as YEARMONTH.
- On the other hand, in the same dataset uploaded by URL from google spreadsheet it does not detect any error.
- I change the field to DATE at xlsx file and the error disappears, but in fact, it is not the original format that I need.