Data processing to fix dates

[jeancochrane]

No description provided.

[glw]

• Dates standardized
• filtering updated to select date range rather than selecting from a list of unique values
• form for Editing or adding a new documents should have a date selector rather than simple text input.

These updates should be made across all data sets (Flat Drawings, Licenses, Surveys, etc.)

[smcalilly]

breaking down the above list:

• dates standardized. do all of this on staging to test and then we can do it on production
  • find all of the date fields. are any of them free text? are there a few common formats/patterns we can use to write a script to standardize that data?
  • update all of the date fields to use the Django model date fields
  • write a script that converts the existing date data into the standardized format
  • do this on the production database
• filtering updated to select date range rather than selecting from a list of unique values
  • is this for the search or the CRUD forms? either way, we'll need to use the django forms to render select widgets with the dates
• form for Editing or adding a new documents should have a date selector rather than simple text input
  • standardizing the models' date fields to use a django model date field should help with this. the form should just render a date selector by default. if this doesn't work then we'll need to figure out what's wrong