try using datediff to get the number of days between @start and the birthday

If it is between 0 and 7incl then their birthday is in the next 7 days

Where DATEDIFF(dd,@start ,dob) > 0 and

DATEDIFF(dd,@start ,dob) <=7