Need help with a query

[agentvic]

I have database with a date field and I would like to have a query setup to grab data from it using whatever the current month and year is.

My date field is currently in the 0000-00-00 format.

I wanted to know if this can be done, and any help would be appreciated.

Thanks in advance,
Vic

[devinemke]

SELECT * FROM table WHERE MONTH(date) = MONTH(CURDATE()) AND YEAR(date) = YEAR(CURDATE())

[agentvic]

Much thanks...It worked.

[LoganK]

Please mark this resolved...