Query result problem

i have excel sheet that i return data from it using query result but i need to return only data of current month but when i use condition where month = month(curdate())
i get this error
Error running query: no such function: curdate

The error is straightforward. Your data source doesn’t have a function called curdate(). It also doesn’t have one called mickeymouse() or infinite_money() :wink: . According to our documentation, the QRDS uses SQLite syntax. You can read the documentation here.

If you are comparing months then you can use the following:

WHERE strftime('%m', month) = strftime('%m', 'now')