Date_Add or Date_Sub Trying to minus a year
Hi Guys, I'm trying to minus a year from date field coming from Netsuite. This is what I have but it doesn't seem to be working? SELECT DATE_SUB(ENDING, INTERVAL 1 YEAR) 'Last Year' FROM ACCOUNTING_PERIODS Any suggestions would be great. Andrew
