Doing something like: CASE WHEN {trandate} BETWEEN TO_DATE(ADD_MONTHS(LAST_DAY({today}),-2)+1, 'mm/dd/yyyy') AND TO_DATE(ADD_MONTHS(LAST_DAY({today}),-1), 'mm/dd/yyyy') THEN 'YES' ELSE 'NO' END does exactly what I'd expect