Distinguishing changes that happen monthly

[JoelR]

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

[almeids]

extract(month,[your date])=extract(month,current_date)-1    ???

[blom0344]

extract(month,[your date])=extract(month,current_date)-1    ???

Code Select Expand



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

[almeids]

Thanks for paying attention Ties, bad oversight on my part.