Data processing to fix dates

[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