updated records within 1 year of closingdate

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

danmarc92 - 03 Jul 2008 10:56 GMT

Thanks for your help with previous post, the queries given do work but I
actually need to restrict the records to a year from the closingdate, not a
year from current
date, does anyone know how to achieve this?.
Thanks

Reply to this Message

Roy Harvey (SQL Server MVP) - 03 Jul 2008 12:13 GMT

Since you started a new thread I don't have the original information
handy. Is the closingdate in the same table as the date being tested?
Is it in another table? You need to provide more information.

Roy Harvey
Beacon Falls, CT

>Thanks for your help with previous post, the queries given do work but I
>actually need to restrict the records to a year from the closingdate, not a
>year from current
>date, does anyone know how to achieve this?.
>Thanks

Reply to this Message