Thank you to all who replied. Here is what I finally came up with. It isn't elegant, but it does get the job done.

DECLARE @todaysdate DATETIME

set @todaysdate =...