I have a column having datatype integer which is in the format yyyymm (e.g. 201905). I want to check if this column is in between start and end date i.e.:

```
case 
  when [cov_yyyymm] between [start_dt] and [end_dt] then 'Period1'
  else 'OtherPeriod' 
end

```

note: start and end dates are datetime

I have tried converting the Int to datetime/date. similarly vice versa from date to int and still could not get it to work.

I expect to use a CASE statement to compare if the Integer is in between 2 dates.