Listing all Costumers with birthday today or tomorrow using Sequelize.js.

routes.js

router.get('/api/birthday', function (req, res, next) {
  var month = moment().month() + 1;
  var today = moment().date();
  var tomorrow = moment().add(1, 'days').date();
  Costumer.findAll({
    attributes: ['id','name','birthDate'],
    where: {
      $and: [
        sequelize.where(sequelize.fn('month', sequelize.col("birth_date")), month)
      ],
      $or: [
        sequelize.where(sequelize.fn('day', sequelize.col("birth_date")), today),
        sequelize.where(sequelize.fn('day', sequelize.col("birth_date")), tomorrow)
      ]
    },
    order: [
      sequelize.fn('month', sequelize.col("birth_date")),
      sequelize.fn('day', sequelize.col("birth_date")),
      'name'
    ]
  }).then(function (result) {
    res.status(200).json(result);
  });
});