CODEWITHSUNDEEP
regexdatabasemongodbmongoosefind
mahdi
mahdi

Reputation: 493

MongoDB find document with Date field using a part of Date

i want to search a date like the following:

09-11
03-22

and it will search in the available documents and bring the matched documnet. an available document example :

2022-09-11T15:31:25.083+00:00

how can i do this?

i tried following query but that didn't work:

db.users.find({ createdAt: new RegExp('09-11') }) // Null

Upvotes: 1

Views: 375

Answers (2)

NeNaD
NeNaD

Reputation: 20334

You can do it with aggregate query:

  • $toString - to convert date to string
  • $regexMatch - to apply regex search
db.collection.aggregate([
  {
    "$match": {
      "$expr": {
        "$regexMatch": {
          "input": {
            "$toString": "$createdAt"
          },
          "regex": "09-11"
        }
      }
    }
  }
])

Working example

Upvotes: 1

artiomi
artiomi

Reputation: 625

Using aggregate you can extract $dayOfMonth and $month from initial date, filter using$match and after $project the initial document by excluding calculated day and month from the document.

db.users.aggregate([
  {
    $addFields: {
      month: {
        $month: "$createdAt"
      },
      day: {
        $dayOfMonth: "$createdAt"
      },
      
    }
  },
  {
    $match: {
      month: 9,
      day: 11
    }
  },
  {
    $project: {
      month: 0,
      day: 0
    }
  }
])

Upvotes: 1

Related Questions