Im convert match field to timestamp then compare. Resolved [
{
"$addFields": {
"timestamp": {
"$toLong": "$modified_at"
}
}
},
{
"$match": {
"timestamp": {
"$gte": ${stored.state:toDate("yyyy-MM-dd HH:mm:ss"):toNumber()}
},
"timestamp": {
"$gte": ${current.state:toDate("yyyy-MM-dd HH:mm:ss"):toNumber()}
}
}
},
{
"$skip": ${offset}
},
{
"$limit": ${limit}
},
{
"$project": {
"code": 1
}
}
]
... View more
