Count Documents based on admission date in mongodb using mongoose

Question

I'm counting the documents based on admission date of students by #using mongoose library

I have tried with new Date() and new Date().toISOString()

parameters = {
          "startDate": "2013-01-01T00:00:00+05:30",
          "endDate": "2013-12-31T23:59:59+05:30"
        }

var prom = student.find({
     admissiondate: {
         $gte: new Date(parameters.startDate),
         $lte: new Date(parameters.endDate)
        }
        }, { _id: 0, admissionno: 1, firstname: 1, lastname: 1 })

#for date to isostring
var prom = student.find({
           admissiondate: {
               $gte: new Date(parameters.startDate).toISOString(),
               $lte: new Date(parameters.endDate).toISOString()
           }
       }, { _id: 0, admissionno: 1, firstname: 1, lastname: 1 })

Expected: a number (ex: 12)

ERRORS:

for new Date()

CastError: Cast to date failed for value "Invalid Date" at path "admissiondate" for model "students"

for new Date().toISOString()

RangeError: Invalid time value at Date.toISOString ()

if I take your `parameters` and run this in the browser console: `var y = new Date(parameters.startDate);` it gives me `Mon Dec 31 2012 19:30:00 GMT+0100 (Ora standard dell’Europa centrale)` — GrafiCode, Jun 27 '19 at 09:36

score 0 · Answer 1 · answered Jun 27 '19 at 11:07

0

Try changing new Date() to ISODate()

var prom = student.find({
           admissiondate: {
               $gte: ISODate(parameters.startDate).toISOString(),
               $lte: ISODate(parameters.endDate).toISOString()
           }
       }, { _id: 0, admissionno: 1, firstname: 1, lastname: 1 })

Mongoplayground

answered Jun 27 '19 at 11:07

Anton

3,587
2
12
27

javascript will say ISODate is not defined – rithesh Jun 28 '19 at 04:54
here is the link about it -- https://stackoverflow.com/q/8848314/9037185 – rithesh Jun 28 '19 at 04:58

Count Documents based on admission date in mongodb using mongoose

I'm counting the documents based on admission date of students by #using mongoose library

I have tried with new Date() and new Date().toISOString()

for new Date()

for new Date().toISOString()

1 Answers1