I have a table with a date field
I have a query where I filter the results according to one filed but I would also like to list only records for current month.
I'm trying to use one of these:
= 'MONTH(DataEntradaProcesso) = MONTH(GetDate())'
= 'MONTH(DataEntradaProcesso) = MONTH(CURDATE())'
But I get the error:
"your entry cannot be converted to a valid date time value"
Also tried to create a new date column, just to check if there was something I had changed that I didn't remember, but I get the same error...
Can anyone give me a hand?
Thanks in advance.