CODEWITHSUNDEEP
mongodbexpressmongoosemongodb-query
Ahmet Yasin Türkyılmaz
Ahmet Yasin Türkyılmaz

Reputation: 400

MongoDB get specific fields between dates

For example I have an object like this

{
    id: string,
    createdAt: Date,
    createdBy: string,
    height: number,
    weight: number,
    fatPercentage: number,
    musclePercentage: number,
    shoulder: number,
    arm: number,
    forearm: number,
    chest: number,
}

How do I get only fatPercentage and createdAt values between a specific createdAt date in a MongoDB query?

Upvotes: 0

Views: 194

Answers (1)

mohammad Naimi
mohammad Naimi

Reputation: 2359

if your mongoose in version 5 :

Model.find({createdAt:{$gt:ISODate(startDate),$lt:ISODate(endDate)}).select('createdAt fatPercentage')

if version 6 :

Model.find({createdAt:{$gt:ISODate(startDate),$lt:ISODate(endDate)},'createdAt fatPercentage')

if mongo driver :

db.collection.find({createdAt:{$gt:ISODate(startDate),$lt:ISODate(endDate)},{createdAt:1, fatPercentage:1})

Upvotes: 3

Related Questions