You may find that MongoDB Search (via Atlas, Community, and Enterprise) can help with regex queries. Here's an article that details the various techniques and best practices: MongoDB Text Search: Substring Pattern Matching Including Regex and Wildcard, Use Search Instead (Part 3)

One idea could be to use index-time analysis to index the date patterns of interest and then be able to find those quickly (match all docs that contain such a value).