Search by ISODate with Wildcard?

[Chase_Russell1 (Chase Russell)]

im trying to find all records that have a date that contains 00:00:00 in the hour minute and second portion to find documents that errored out in our subscription service. Was trying to use this but its erroring out.

db.CustomerSubscriptions.find({"UpcomingOrders.NextOrderDate": ISODate("/.*00:00:00.*/")})

[Pavel_Duchovny]

Hi @Chase_Russell1 ,

The regex is only working on strings in a regex syntax.

What you need is probably to use aggregation with $dateToParts operator and $match all the documents that answer this time:

$dateToParts (aggregation) — MongoDB Manual

[{$unwind: {
  path: "$UpcomingOrders"
}}, {$addFields: {
  dateParts: { $dateToParts :  { date :"$UpcomingOrders.NextOrderDate" }}
}}, {$match: {
  "dateParts.hour" : 0,
  "dateParts.minute" : 0,
  "dateParts.second" : 0
}}]

Thanks,
Pavel

[Chase_Russell1 (Chase Russell)]

Thank you Pavel, I appreciate that!