NOAA-PMEL/excel2oap

Fails to properly pickup start and end times from excel files exported to csv

lkamb opened this issue · 0 comments

lkamb commented

Depending on how the user has their date cell format set, a metadata spreadsheet exported to csv can result in a date that cannot be properly interpreted by the SDIMetadata (used internally) Datestamp class. Default date format appears to be yy/mm/dd, whereas the Datestamp expects yyyy/mm/dd.

Translating directly from Excel files does not suffer this issue.