• Ryan Keast (5/28/2014)


    Legend. Thanks Phil

    No problem. And if you want to ignore the time component, you might like to use

    dateadd(d,-7,cast(getdate() as date))

    instead.