The TRUNC function Converts a date to the date at midnight

So,
select field_name from your_table
where ActivateDate >= trunc(last_day(add_months(CURRENT_DATE,-2))+1) and ActivateDate < trunc(last_day(add_months(CURRENT_DATE,-1))+1);



good luck !!