Question

0

128

Visualizações

Apply filter on date in mongodb

I have a field named RechargeDate in mongo :

"Recharge_Date" : ISODate("2022-06-13T00:00:00.000Z")

Now, I need to apply filter on it based on today's date. If today's date is any of 1 to 10 of a month, then filter should be such that when it gets applied on find function of mongoose, it fetches the record between 1 to 10th of Month of Recharge_Date.

Similarly, if today's date is any of 11 to 20 of a month, then filter should be such that when it gets applied on find function of mongoose, it fetches the record between 11 to 20th of Month of Recharge_Date.

I want to know how the filter query would look like.

about 4 years ago · Santiago Gelvez

1 Respostas

Responde à pergunta

0

Responde à pergunta

Encontrar trabalhos remotos

Answer 1 · 2022-07-22T17:15:28.071Z

You can use moment.js or similar library:

db.collection.find({ 
  Recharge_Date: {
     $gte: moment().startOf('day').toDate(),
     $lte: moment().endOf('day').toDate()
  }
})

0

128

Apply filter on date in mongodb

1 Respostas

0

Encontrar trabalhos remotos

Andres GPT