Need to generate a weekly report in asp -- DateFormat(Now() - 7 days

[theladycoder]

I am trying to generate a report in asp that breaks down sales, credits, misc daily, weekly, month. Not sure how to do this. The date format in the db is yyyy-mm-dd.