How do I update a property with the current date in a Mongoose schema on every save?

Question

In my database collections, I want to update a 'lastChanged' field every time the record is updated with the current datetime. I want it to be in the same format as mongoose's default date like:

ISODate("2011-10-06T14: 01: 31.106Z")

Any words of wisdom?

score 28 · Answer 1 · answered Jan 29 '12 at 20:51

28

If you just want an ISO String use:

new Date().toISOString()

answered Jan 29 '12 at 20:51

greenimpala

3,777
3
31
39

5

Sorry, I don't think this answers the question. The question was not, "how do I create an ISO string". – Dave Jensen Apr 10 '14 at 21:10
5

This is how you create a valid ISO string to insert into Mongo. – greenimpala Apr 11 '14 at 09:20

score 17 · Answer 2 · edited May 23 '17 at 12:02

One way of accomplishing this is to use Mongoose Middleware and update the field pre-save.

var mongoose = require('mongoose');
var Schema = mongoose.Schema;
//schema
var SomethingSchema = new Schema({
  text: {type: String},
  createdAt: {type: Date, default: Date.now},
  updatedAt: {type: Date, default: Date.now}
});

//middle ware in serial
SomethingSchema.pre('save', function preSave(next){
  var something = this;
  something.updatedAt(Date.now());
  next();
});

It seems, however, that the middleware is not always invoked:

Notes on findAndUpdate()

pre and post are not called for update operations executed directly on the database, including Model.update,.findByIdAndUpdate,.findOneAndUpdate, .findOneAndRemove,and .findByIdAndRemove.order to utilize pre or post middleware, you should find() the document, and call the init, validate, save, or remove functions on the document. See explanation.

Update: See this question "add created_at and updated_at fields to mongoose schemas"

You can now invoke middleware for `update` in >MongooseJS 4.0 — steampowered, Aug 14 '15 at 17:54
instead of Date.now which gives system specific timestamp, you can use moment.now() from moment package which gives current time based on your timezone — Viraj Singh, May 13 '19 at 08:23

Salvador Dali · Answer 3 · 2013-10-25T09:07:56.300

11

In a few days Mongo is going to announce new 2.6 version (currently you can download experimental 2.5.x version). Among many other features you can use $currentDate which is going to do exactly the thing you want:

db.users.update( 
  <criteria>,
  {
     $currentDate: { yourField: true},
  }
)

edited Oct 25 '13 at 09:07

answered Oct 25 '13 at 09:02

Salvador Dali

214,103
147
703
753

score 0 · Answer 4 · answered Sep 19 '20 at 08:38

0

The middleware function is a good approach, however, it should be

SomethingSchema.pre('save', function preSave(next){
  var something = this;
  something.updatedAt = Date.now();
  next();
});

Since something.updateAt is not a function.

answered Sep 19 '20 at 08:38

Wang Yi

1

score 0 · Answer 5 · edited Feb 25 '21 at 17:54

I added updated: new Date to fix a similar problem. Here is how I used it.

update: (req, res) => {
        let userId = req.params.id;
        let userParams = {
            name: {
                first: req.body.first,
                last: req.body.last
            },
            email: req.body.email,
            password: req.body.password,
            updated: new Date
        };

        db.User.findOneAndUpdate(userId, { $set: userParams })
            .then(upUser => res.json(`Profile Updated for: ${upUser.fullName}`))
            .catch(err => res.status(422).json(err));
    }

How do I update a property with the current date in a Mongoose schema on every save?

5 Answers5

Linked