Use DateAdd in a query

[tekspaz]

I am developing a report that is creating columns for 'Units_Sold' based on dates. I have already created a system object that queries the database and stores the max date found in the appropriate table. Now, I would like to query the data again and only pull the 'Units_Sold' for the week prior to the Current date.

I have created another query and am selecting 'Units_Sold' where 'Week_Ending' = Dateadd("d",-7,'Current_Week').

This doesn't seem to work. Any suggestions?

 

[ShyamRewaskar]

You should have mention what database you are using...
Ok I will give an example for MS-Access database.

Create a condiion in the universe, and write
"Format(Sales.invoice_date,'WW') = Format(date()-7,'WW')"
in the where clause.

and add this condition in the report's dataprovider condition window...this will give you the data for last week

Shyam