search

cidgoh / GRDI_AMR_One_Health

A data specification for harmonizing One Health AMR pathogen genomics contextual data. The specification provides standardized (ontology-based) fields and terms which are implemented via a spreadsheet collection template, supported by field and reference guides as well as different curation and new term request SOPs.
MIT License
7 stars 0 forks source link

Template: allowable date formats #16

Closed cmrn-rhi closed 1 year ago

cmrn-rhi commented 1 year ago

Currently it only allows "YYYY-MM-DD" but we'd like for it to accept "YYYY" and "YYYY-MM" as well. Likely need to turn off the excel date format and encode this in VBA.

cmrn-rhi commented 1 year ago

Tried to work around Excel date autoformatting and date validation but could not find a solution that both validated dates and allowed for the input of multiple date formats. Can be resolved in the future if we move to using a DataHarmonizer template.