Perhaps you could utilize this:
Select * from [provider].[tbl_msow_practitioner_id_numbers] where Month(Expiration_date) = Month(DateAdd(m,-1,GetDate())) and Year(Expiration_date ) = Year(DateAdd(m,-1,GetDate())