Core: parse error while filtering data by created_at

[krunaldodiya]

const User = use("App/Models/User");

// this is not working.. and no any example of filtering data by dates.. please help
const records = User.query().where("created_at", "<", Moment().substract(1, "day"));

// i am trying to fetch all users who were registered atleast 24 hours/ 1 day ago or before .. not today.
but it gives parse error

[webdevian]

You need to format the moment date object as a mysql friendly string:

const yesterday = Moment().substract(1, 'day').format('YYYY-MM-DD HH:mm:ss')
const records = User.query().where('created_at', '<', yesterday)

[thetutlage]

Closing since @webdevian answered the question.

[lock[bot]]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.