How can I get last week counts

jd · 24 Nov 2008 12:08:14 PM

Any Idea How can I get last week counts in my report.

Suraj · 24 Nov 2008 12:36:41 PM

case

when ([Date Column] >= adddays(current_date,-7) and [Date Column] < current_date) then (count ([Apps])

else null

end

BSP Software	Resources	About Us
MetaManager	BSP Software Training	BSP Software
Integrated Control Suite	YouTube Channel	Micro Strategies Inc
Security Migration		IBM Cognos
Integrated Management Suite

If you are unable to create a new account, please email support@bspsoftware.com