Ok...back to the starting point.
First, I create a table to test my start/end intervals:
data have;
do i=1 to 12;
test_date=mdy(i, 4, 2015);
start= intnx('month', test_date, -1, 'b')+20;
end= intnx('month', test_date, 0, 'b')+19;
output;
end;
format test_date start end date9.;
run;
proc print;
run;
Once you're sure the formula's are correct you can change test_date to today() and place in your WHERE clause.
PROC SQL;
SELECT * FROM TASK_Current1
WHERE DATEPART(TASK_Current1.LAST_UPDATE_DATE) NOT BETWEEN
(intnx('month', today(), -1, 'b')+20) and (intnx('month', today(), 0, 'b')+19);
;
QUIT;
... View more