I have a table which holds the information of licences and when they are due to expire (date).
I would like to create a DTS package to run a query every month to show which dates are due to be renewed 3 months ahead, so this month, I want to see all of the dates due to expire is October. At the moment I am opening up the query every month and showing where the dates are between '2012-10-01' and '2012-10-30'. Is it possible to use the GETDATE code to show this information.
I have been doing lots of research, I have found this code (r.rendate = dateadd(m,+3,getdate())) which shows me all results in 3 months and anything after, I have also had one that shows me everything prior to 3 months and the 3 month date.
Can anyone suggest a better way of doing this?