ok i am working on a sql and having problems....
what i want to do is to select all rows that are from this day one year ago. here is my query:
TO_DAYS(NOW()) = TO_DAYS(orderDate) AND YEAR(date_add(NOW(), interval '-1' year)) = YEAR(orderDate)
the year must remain seperate from the day.