I my collection there are multiple formats of date in the different documents. i.e. some with “MM/DD/YYY” and some with “MM/DD/YY HH:MM:SS AM” how do I filter out those that match only MM/DD/YYYY format.
Hello @Vivek_02262, include sample documents showing the actual data - the date field and its different formats. Also, tell if the date field is stored as a date type field or as a string?