Keep in mind that getdate() is non-deterministic, so that if it happens to be using that your result will forever be non-deterministic.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?