See also #771
This syntax is not human readable as an artifact of reliance pymongo's extended json capabilities. It's only used in this single column. The tables in all the clusters are very small (~80MB) so I don't see a problem with rewriting this data.
Steps:
- Adapt CRM side code that parses $date, to also accept normal ISO serialization of datetimes, like we do everywhere else. We currently ingest this data to CRM through sync-engine's API to calculate account status and delays.
- Ship a change to sync-engine that uses ISO datetimes instead of $date
- Run a script to convert all the data in sync-engine
- Remove inbox/sqlalchemy_ext/json_util.py and just use stdlib's json module
- Drop support for $date from CRM side
sync-engine/inbox/models/account.py