Ways to retrieve records within a specified date range in MongoDB?

Question

Ways to retrieve records within a specified date range in MongoDB?

I have a data record in my mongodb collection with the field "birth_date" set to "1983-05-06T16:26:32.613Z".

Below is the find query I used to retrieve this record within a specific date range:

var birthYear = 1983;
var birthDateStart = new Date('1.1.' + birthYear); 
var birthDateEnd = new Date('12.30.' + birthYear); 
    var cursor = db.collection('users').find({
            birth_date: {$gte: birthDateStart, $lt: birthDateEnd}
        })

It seems like the issue lies in the date format. How can I get the same Date() format as the one stored in the database?

I utilized variety tool to analyze the DB schema:

+--------------------------------------------------+
| key          | types    | occurrences | percents |
| ------------ | -------- | ----------- | -------- |
| _id          | ObjectId |           1 |    100.0 |
| bio          | String   |           1 |    100.0 |
| birth_date   | String   |           1 |    100.0 |
+--------------------------------------------------+

As I am using the 'mongodb' package for express.js, I encountered an error when trying to use ISODate().

ReferenceError: ISODate is not defined

javascript mongodb date

Answer 1

Answer №1

Appreciate all the hints provided. The main issue was that the field birth_date was being saved as a String.

This answer aims to demonstrate how to convert a field from String to Date format for all records in your collection, and also how to search by Age (in years) when only the birthdate is saved. Hopefully, this will benefit others facing a similar challenge.

To change the format of the field 'birth_date' from String to Date:

mongo.connect(url, function (err, db) {
        console.log(err);
        var resultArray = [];
        var cursor = db.collection('users').find({});
        cursor.forEach(function (doc, err) {
            console.log(doc);
            db.collection('users').update({_id: doc._id}, {$set: {birth_date: new Date(doc.birth_date)}});
        }, function () {
            db.close();
            res.send("Done!");
        })
    })

Search for a user who is 18 years old:

var search_age = 18;
var birthYear = new Date(Date.now()).getFullYear() - search_age;
var birthDateStart = new Date(birthYear, 0, 1);
var birthDateEnd = new Date(birthYear, 11, 31, 23, 59, 59, 999);
var resultArray = [];

mongo.connect(url, function (err, db) {
    console.log(err);
    var resultArray = [];
    var cursor = db.collection('users').find({
            birth_date: {$gte: birthDateStart, $lt: birthDateEnd},
        });
    cursor.forEach(function (doc, err) {
        resultArray.push(doc);
    }, function () {
        db.close();
        res.send(resultArray);
    });
})

Answer 2

Appreciate all the hints provided. The main issue was that the field birth_date was being saved as a String.

This answer aims to demonstrate how to convert a field from String to Date format for all records in your collection, and also how to search by Age (in years) when only the birthdate is saved. Hopefully, this will benefit others facing a similar challenge.

To change the format of the field 'birth_date' from String to Date:

mongo.connect(url, function (err, db) {
        console.log(err);
        var resultArray = [];
        var cursor = db.collection('users').find({});
        cursor.forEach(function (doc, err) {
            console.log(doc);
            db.collection('users').update({_id: doc._id}, {$set: {birth_date: new Date(doc.birth_date)}});
        }, function () {
            db.close();
            res.send("Done!");
        })
    })

Search for a user who is 18 years old:

var search_age = 18;
var birthYear = new Date(Date.now()).getFullYear() - search_age;
var birthDateStart = new Date(birthYear, 0, 1);
var birthDateEnd = new Date(birthYear, 11, 31, 23, 59, 59, 999);
var resultArray = [];

mongo.connect(url, function (err, db) {
    console.log(err);
    var resultArray = [];
    var cursor = db.collection('users').find({
            birth_date: {$gte: birthDateStart, $lt: birthDateEnd},
        });
    cursor.forEach(function (doc, err) {
        resultArray.push(doc);
    }, function () {
        db.close();
        res.send(resultArray);
    });
})

Ways to retrieve records within a specified date range in MongoDB?

Answer №1

Similar questions

Struggling to set up an HTTPS server with Express and Node.js - it just won't start

Tips for efficiently storing and managing large data volumes in real-time applications

I'm encountering an issue where I receive the error `Cannot read property 'map' of undefined` while attempting to integrate the backend with React. What could be causing this error and how

Labeling src library files with namespaces

Sliding with JavaScript

What is the process for creating a list using layers that are published in Geoserver?

The definition of Csrftoken is missing

The functionality of HTML5 canvas image objects is not functioning as expected

Opting for PHP over JSON for the instant search script output

Tips for creating a sophisticated state transition diagram using Typescript

Button will be disabled unless a value is selected in the dropdown menu

Do you always need to use $scope when defining a method in Angular?

Issue with React Testing Library: Attempting to access the 'contents' property of an undefined value in Redux

Leveraging the package.json file for client-side packages, enabling them to be dynamically loaded in the browser

Tips for generating a <div> element with multiple children using a loop

Utilize React-markdown to interpret subscript text in markdown format

Is there a way to transform MongoDB Controller elements into JSON using perl?

Generating a dynamic sitemap with Next.js

What is the best way to ensure that the swf loads only after all the images and text have loaded completely

The difference between using an event listener directly in HTML vs. using the add