[BUG]: Incorrect date type stored in MongoDB

[gdude2002]

Bot Version

v3.10.2

How are you hosting Modmail?

Patreon

Error Logs

N/A

Screenshots

Sample thread document

Metabase error

Additional Information

This isn't so much a user-level bug as it is a data integrity issue.

When attempting to make use of the data stored in the MongoDB database managed by the modmail bot, it's impossible to filter or group based on dates because fields such as created_at are strings, rather than actual valid MongoDB dates.

A fix (and database migration step) for this issue is probably a good idea - not just so that one can perform statistical analysis against the database using external tools, but also just to improve overall data integrity.