date calculations

[mossbs]

hey guys,

right, i need to write a procedure to add in a renewal payment plan for members.

the adding in bit is fine its just the pulling the correct people i am struggling with due to calculating dates etc.

our renewals process starts 2 months before they are due to renew etc so if i were to run it today i would need to pull people for may etc.

my problem lies in that members will have an 'attribute' on their record which is a ref number linked to a lookup table that gives the description of that attribute reference but i also need to include getdate into the equation to calculate 2 months in advance etc.

so essentially i need to pull people where the description (lookup_full_desc) = datename(month, getdate()) (but plus 3 months)

any ideas?

as always... apologies if none of the above makes sense - has been a long day!

cheers,

dan

 

[PWise]

(lookup_full_desc) = datename(month,dateadd(m,3,getdate())

 

[mossbs]

pwise....you sir are a gent!

i knew it was something along those lines just couldnt remember the correct syntax!

cheers buddy!

dan