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
This site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.
jesse
2
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() 
. 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')