Document the expected input format of any DATE value

hickeng / financial

Repository containing financial spreadsheets

Other

207 stars 24 forks source link

Document the expected input format of any DATE value #130

Closed yahhhya closed 7 months ago

yahhhya commented 8 months ago

George, per habit I entered Release Dates in MM/DD/YY format, but noticed that the sheet interpreted that as DD/MM/YY, affecting basis + long/short term determination. I wonder if explicitly stating the formatting expectation (eg: "Release Date (in DDxMMxYY format)") would help avoid mistakes?

jonatan-ivanov commented 8 months ago

Use ISO 8601: YYYY-MM-DD and google sheets (and everyone else) will be happy. ;)

https://xkcd.com/1179/

hickeng commented 8 months ago

@yahhhya Ack - wasn't an issue prior to v0.1.7 as the dates were pre-filled.

Closing this as a dup against #129. As noted there I'll be shifting the Month to be Jan, Feb, as it's the only way to provide useful inline feedback.

hickeng commented 8 months ago

Updated the sheet in-place to be v0.1.7-b with adjustment to date format and example iso-date format inline in the first data cell. Added doc notes in various places in usage.md about the issue.