sql - SEQUELIZE - Invalid Value For Date

Question

My sequelize WHERE condition looks like this:

 where: {
    [Op.and]: opAnd,
    [Op.gte]: [{order_date: moment(new Date(req.body.orderDateRange.trim().split("-")[0])).format("YYYY-MM-DD"), order_signing_date: moment(new Date(req.body.signingDateRange.split("-")[0])).format("YYYY-MM-DD")}],
    [Op.lte]: [{order_date: moment(new Date(req.body.orderDateRange.trim().split("-")[1])).format("YYYY-MM-DD"), order_signing_date: moment(new Date(req.body.signingDateRange.split("-")[1])).format("YYYY-MM-DD")}],
}

but it keeps returning an "Invalid Value" error at whatever date I throw at it:

Error: Invalid value { order_date: '2015-12-01', order_signing_date: '2020-12-09' }

I am running PostgreSQL on my backend. My order date is coming as a range, for example, "12/01/2000 - 12/01/2020". From the split, it is taking the first date and searching for order dates greater than or equal to it, and taking the second date and searching for order dates less than or equal to it.

I also tried this combination, but it still spits the same error (Side question: Which format is the correct one?):

 where: {
    [Op.and]: opAnd,
    [Op.and]: [{[Op.gte]:{order_date: moment(new Date(req.body.orderDateRange.trim().split("-")[0])).format("YYYY-MM-DD"), order_signing_date: moment(new Date(req.body.signingDateRange.split("-")[0])).format("YYYY-MM-DD")}}],
    [Op.and]: [{[Op.gte]:{order_date: moment(new Date(req.body.orderDateRange.trim().split("-")[1])).format("YYYY-MM-DD"), order_signing_date: moment(new Date(req.body.signingDateRange.split("-")[1])).format("YYYY-MM-DD")}}],
}

Answer 1

等待大神答复