search

ODM2 / YODA-File

The YAML Observation Data Archive & exchange (YODA) File Format
BSD 3-Clause "New" or "Revised" License
4 stars 0 forks source link

"AffiliationStartDate" column in "Affiliations" table #39

Closed cdesyoun closed 8 years ago

cdesyoun commented 8 years ago

Jeff, the data type for "AffiliationStartDate" and "AffiliationEndDate" is "Date" type, not "Datetime" type. In generated timeseries yoda file, 

,AffiliationStartDate: "2014-01-01 00:00:00", 
,AffiliationStartDate: "2015-01-01 00:00:00",

When validating it, the error was occurred. The correction is as follows:

,AffiliationStartDate: "2014-01-01", 
,AffiliationStartDate: "2015-01-01",
horsburgh commented 8 years ago

@cdesyoun - I'll have to look into this one and see if I can get Excel to spit out just the date string without the time.

horsburgh commented 8 years ago

This should be fixed in the new Time Series Excel template and in the example. @cdesyoun - can you have a look and close this issue if you are satisfied?

cdesyoun commented 8 years ago

It is awesome! when testing this updated YODA file, the validating process was successful. Thanks for the quick update, Jeff.