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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Date calculation

Started by sunny1234, 13 Dec 2007 08:12:51 PM

Previous topic - Next topic

sunny1234

We have a column status need to filter the data, date of this status associated
need to take the count of status and get the count of last 30 days.
status IN ('c1', 'c2') & count of c1, c2 last 30 days

status   date

c1        2001-04-08
c2        2004-01-01
c3        2004-01-02
c4        2005-02-04

Please explain how to accomplish this
here i need to find out count of days between sysdate and date check the null value of date if it is null --> add_months(sysdate, -1)
and find out status count of last 30 days.