search

LibraryCarpentry / lc-spreadsheets

Tidy data for librarians
https://librarycarpentry.github.io/lc-spreadsheets/
Other
22 stars 38 forks source link

Dates as data - adding ISO standard #33

Closed cjbakker closed 4 years ago

cjbakker commented 5 years ago

In the "storing dates as a single string" section, I would suggest modifying the last sentence as follows:

"You could also use the 'YYYYMMDD' format. YYYYMMDD is an international standard (ISO 8601) and can eliminate ambiguity when sharing spreadsheets. Such strings will be correctly sorted in ascending or descending order, and by knowing the format they can then be correctly processed by the receiving software."

The word ascending is also currently misspelled (missing the "i").

shlake commented 5 years ago

Will look at the lesson and incorporate the ISO standard (that's what YYYYMMDD is) in this section: "Storing dates as a single string". Will make it more explicit.

shlake commented 4 years ago

Added ISO standard info in @shlake branch (to be merged soon).