MongoDB Find Query by year

Question

How to perform a find() operation with a condition like {fromdt: 2016} where fromdt is an ISODate in the backend. After checking stackoverflow posts, I could see only one option that uses $year with aggregation. But basically it uses projection and I dont get all fields in the document. So I would like to know how to achieve this without aggregation? Basically I want to apply the mentioned filter and get all documents with all fields in each.

example document:

{
"_id" : 501.0,
"custid" : 1.0,
"fromdt" : ISODate("2016-01-23T00:00:00.000Z"),
"enddt" : ISODate("2017-01-22T00:00:00.000Z")
}

Is there a better way without having to remember the format 2016-01-01T00:00:00.000Z by just giving the year value filter as 2016?

Try `db.col.find({ "$expr": { "$eq": [{ "$year": "$fromdt" }, 2016] } })` in 3.6 — s7vr, Mar 08 '18 at 13:56
Its similar. You just need to use year instead of month. Look at [here](https://stackoverflow.com/a/42513078/2683814). Is that not what you want ? — s7vr, Mar 08 '18 at 14:09

score 11 · Answer 1 · answered Mar 08 '18 at 13:43

11

You can try this, Date between 2016-01-01 to 2017-01-01

db.getCollection('TEST').find({
    "fromdt": {
        $gte: ISODate("2016-01-01T00:00:00.000Z"),
        $lt: ISODate("2017-01-01T00:00:00.000Z"),
    }
})

answered Mar 08 '18 at 13:43

Rahul Sharma

9,534
1
15
37

1

Thanks for the response, is there a better way without having to remember the format `2016-01-01T00:00:00.000Z`? – Rahul Raj Mar 08 '18 at 13:48

MongoDB Find Query by year

1 Answers1