How do i get clients who have been enrolled for 12 months continously.

Question

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Karen Roslund SSCommitted Points: 1724 More actions · Answer 1

Thanks for the answers and this is what i ended up doing

select client_Id from tbl where and eff_dt = @enddt) and datediff(mm, eff_dt, exp_dt)>=12