Nodejs API querying mongodb using date

Question

I am having trouble querying mongodb using user's birth date. The client application is sending birth date as a string in "MM-DD-YYYY" format. I am getting no result although the user is an my database. How do I structure my application query in order to convert date inside a string to ISODate?

Here is the client request

{"firstName": "Mark",
  "lastName": "Tony",
  "birthDate": "06-25-1990"
}

Here is my query

db.user.findOne({
  'firstname': req.body.firstName,
  'lastname': req.body.lastName,
  'dob': req.body.birthDate
});

Yashwin Munsadwala · Accepted Answer · 2018-03-25 21:22:14Z

1

First of all make sure you convert dob object into date format from the client side and convert object received on server into date too.

var date = new Date(req.body.birthDate) //converting into date format 
date = date.toISOString() // converting to iso format date

similarly send data to server from client side in similar manner ! I hope this helps

answered Mar 25, 2018 at 21:22

Yashwin Munsadwala

5241 gold badge8 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Darshana Peiris · Accepted Answer · 2018-03-25 05:52:46Z

0

Use JS Date object to convert string to ISO Date.

More Info : JS Date Object

answered Mar 25, 2018 at 5:52

Darshana Peiris

12 bronze badges

1 Comment

sparkitny Over a year ago

Not enough detail, please reference which parts of the link you added to your response actually answer the question. Need to be specific. Read the SO guidelines before posting.

Collectives™ on Stack Overflow

Nodejs API querying mongodb using date

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related