I'm trying to write a case when the month and year within date field (move\_in\_month) is equal to the current month/year. I wrote: 

```
  when date_part(m,temp.move_in_month) = date_part(m,getdate()) and date_part(y,temp.move_in_month) = date_part(y,getdate()) and engagement_rate <= .4 then 'Flag' 
  else 'No Flag' end as low_use_yn

```

and have also tried several other variations, but it's not working. Thoughts? Thanks!