[BUG]: Incorrect date type stored in MongoDB #3115
Description
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.