Select all object have date between two date on fields value of mongodb

Question

I have a bit of trouble getting data from mongodb. I have a collection like this:

    Activities = [
          ... some another activity object item ... ,

          {
              type: "special"
              dates: {
                  begin: ISODate("2019-07-07T17:00:00.000Z"),
                  end: ISODate("2019-07-20T17:00:00.000Z"),
                  note: ""
              },
              status: "pending"
          } ,
          ,
          {
              type: "event"
              dates: {
                times: {
                    from: "12:00",
                    to: "15:00"
                  },
                  begin: ISODate("2019-07-21T17:00:00.000Z"),
                  end: ISODate("2019-08-29T17:00:00.000Z"),
                  note: ""
              },
              status: "pending"
          } ,

          ... some another activity object item ...
      ]

I want to get all activity data has : dates.begin < X (my params date) < dates.end . And this is my way i have tried :

_Activities.find({
        "dates.end" : {
            $lte : "2019-08-31T17:00:00.000Z"
        },
        "dates.begin" : {
            $gte : "2019-07-15T17:00:00.000Z"
        }
    }, callback);
// return [];


_Activities.find({
        "dates.end" : {
            $lte : "2019-08-30T17:00:00.000Z"
        }
    }, callback);
// return [] too;

I don't know where I was wrong, anyone has a solution to help me :((( Thanks for taking the time .

score 0 · Accepted Answer · answered Aug 23 '19 at 02:04

0

Because your fields have type Date so you need to pass a Date to compare. Something like this may work:

$lte : new Date("2019-08-31T17:00:00.000Z")

answered Aug 23 '19 at 02:04

Cuong Le Ngoc

11,595
2
17
39

im so tired with this trouble in 2 days , this is work now , thanks you so much guy . have a good day – hieu nho Aug 23 '19 at 02:38
Can I know which version of mongoose you're using? – Cuong Le Ngoc Aug 23 '19 at 02:40
yeah sure , i used mongoose v5.6.6 , what do we need to note in this version friend – hieu nho Aug 23 '19 at 02:49
I just feel strange because i have made some queríes with Date in my project without casting but it still works. Maybe your project has some difference. – Cuong Le Ngoc Aug 23 '19 at 02:58

Yasser Mas · Answer 2 · 2019-08-23T02:33:51.170

0

You can pass dates as javascript Date object it will work

dates: {
  end: { $lte: new Date('2019-08-31T17:00:00.000Z') } ,
  begin: { $gte: new Date('2019-07-15T17:00:00.000Z') }
}

edited Aug 23 '19 at 02:33

answered Aug 23 '19 at 02:05

Yasser Mas

1,652
1
10
14

Dear friend , thanks you for your solution , i tried this way but is still return a null array , maybe mongoosejs do not support this case , but we can use like 'dates.begin' : { $gte: new Date('2019-07-15T17:00:00.000Z') } and 'dates.end' : { $gte: new Date('2019-07-15T17:00:00.000Z') } . Thanks u a lot for taking time ;) – hieu nho Aug 23 '19 at 02:46
Sorry this is why it not working with you https://stackoverflow.com/a/16002726/6113960 – Yasser Mas Aug 23 '19 at 03:03

Select all object have date between two date on fields value of mongodb

2 Answers2