If I have a column that shows by date (i.e. yyyymmdd) the last time the instructions for performing a task had been modified then how do I distinguish those tasks that happened just last month?
For example, now I want to know task changes for the month of March. Next month I want to know task changes for the month of April
extract(month,[your date])=extract(month,current_date)-1 ???
Quote from: almeids on 03 Apr 2008 03:14:48 PM
extract(month,[your date])=extract(month,current_date)-1 ???
CASE WHEN
extract(month,current_date) = 1
THEN extract(month,[your date]) = 12 AND extract(year,[your date])=extract(year,[current_date])-1
ELSE extract(month,[your date]) = extract(month,current_date)-1 AND extract(year,[your date])=extract(year,[current_date]) END
:D
Thanks for paying attention Ties, bad oversight on my part.