Stored procedure with date

[Su Ge]

There is a stored procedure to run each Sunday. I would like to get the order date from previous Sunday through Saturday. Right now we code as
"OrderDate Between convert(datetime, '05/02/99&#39 AND
convert(datetime, '05/08/99&#39 "
Each week the dates have to be manually changed. How to use the date function to make it automated?

[Gregory]

if you run it every sunday:

OrderDate between DateAdd(wk,-1, GetDate()) and DateAdd(dd,-1,GetDate())


------------
Su Ge at 5/7/99 8:26:57 AM

There is a stored procedure to run each Sunday. I would like to get the order date from previous Sunday through Saturday. Right now we code as
"OrderDate Between convert(datetime, '05/02/99&#39 AND
convert(datetime, '05/08/99&#39 "
Each week the dates have to be manually changed. How to use the date function to make it automated?

[Su Ge]

Thank you very much Gregory.


------------
Gregory at 5/7/99 11:38:26 AM

if you run it every sunday:

OrderDate between DateAdd(wk,-1, GetDate()) and DateAdd(dd,-1,GetDate())


------------
Su Ge at 5/7/99 8:26:57 AM

There is a stored procedure to run each Sunday. I would like to get the order date from previous Sunday through Saturday. Right now we code as
"OrderDate Between convert(datetime, '05/02/99&#39 AND
convert(datetime, '05/08/99&#39 "
Each week the dates have to be manually changed. How to use the date function to make it automated?