I am currently investigating an issue where some documents have incorrect values in the ‘date’ field. I have put a TTL index on the field (10 min.). I have found documents to be missing in the collection after refreshing Compass less than a minute after the documents are inserted (some even don’t appear in the collection after insertion at all!). I managed to see the values of the ‘date’ field on some of these documents before their deletion and their values are inaccurate by 10-20 minutes which explains why they were deleted. I plan to changed the TTL duration to 2 days for now.
new Date() to create the values