I know you've seen this before, but I guess is merits posting. Lynn has a page of date calculations that can be used to get you to almost any date relative to today at http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/. I would start there if you want to learn how to use date math efficiently.