Using a query for the full date format in Sails.JS Waterline

According to Between dates using the Waterline ORM SailsJS , you can query between dates in the Waterline adapter as follows:

User.find({
    createdAt: { '>': dateFrom, '<': dateTo }
}).exec(/* ... */);

However, this only works with date formats such as 2018-04-11 . Somehow you can use the full ISO8601 date format in this query: for example. 2018-04-11T12: 45: 00.000Z

EDIT: Added a minimal working code example.

readDataInDateRange: function(req, res) {
    var dateFrom = req.param("dateFrom");
    if (dateFrom == null || dateFrom == ''){
        return res.badRequest();
    }
    var dateTo = req.param("dateTo");
    if (dateTo == null || dateTo == ''){
        return res.badRequest();
    }
    User.find({createdAt: { '>=': dateFrom, '<=': dateTo}})
    .exec(function afterwards(err, users) {
        if (err) {
            sails.log(err);
            return res.serverError(err);
        }
        return res.ok(users);
    });
}
0
source share

All Articles