Skip to content
This repository has been archived by the owner on Mar 12, 2024. It is now read-only.

Determine appropriate date format for sca_capacity_projects #21

Open
mgraber opened this issue Jul 22, 2020 · 0 comments
Open

Determine appropriate date format for sca_capacity_projects #21

mgraber opened this issue Jul 22, 2020 · 0 comments

Comments

@mgraber
Copy link
Contributor

mgraber commented Jul 22, 2020

The input data has two date formats: "SEPTEMBER YYYY" or "YYYY"
Previous output converted these into a date datatype, with format YYYY-MM-DD. This suggests greater temporal resolution than exists in the input data. It also takes all "YYYY" dates and, by default, turns them into "YYYY-01-01." January first might not be an appropriate default for school years.

Potential solutions:

  • Do not output dates as YYYY-MM-DD, but instead as YYYY
  • If we keep the YYYY-MM-DD format, make the default date for YYYY records September 1 rather than January 1
  • As a combination of the two above options, output dates as YYYY-MM, with MM as 09 in all records

All of these depend on what format the front-end expects.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants