This content has been marked as final. Show 7 replies
What is wrong in my where clause:
I have a ODBC connection and I'm trying to limit the data by year and month functions in the query.
This is my where limit and the year seems to work but it gives error with the month "invalid tag".
WHERE YEAR(VOUCHER_DATE)=$(vYear) and MONTH(VOUCHER_DATE)=$(vMonth);
The variables are
And the form of voucher date in the database is
What am I doing wrong?