I have a date field in my SQL table
I have tried this and it works perfectly.
sql = "SELECT * FROM mytable WHERE MONTH(mydate)=3 AND YEAR(mydate)=2005"
But when I try this, i tells me there is a syntax error. Why? How to rectify?
sql = "SELECT * FROM mytable WHERE DAY(my_date)= 27"
I'm totally puzzled since I read from tutorials that you can use the DAY function to rerieve the day from date.