How do i compare dates that are a range? Pls Help :)

[angel0910]

Hi to all

I have a problem..
Let's say i have a date to compare..
Maybe a birthdate...

then i would like to remind the user of this birthdate starting frm 3 days away, then subsequently everyday( 2 days away, 1 day away and the actual day itself)
how do i compare?
thanxs a million

 

[NathanGriffiths]

you could use DATEADD, e.g. to test whether the current date is three days before a BirthDate:

GETDATE() = DATEADD(day, -3, BirthDate)

returns True if they are the same.

cheers

Nathan