Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: katdbc on 22 Sep 2010 04:40:57 PM

Title: I want help in sql part in the filter!!!!!!!!!!!
Post by: katdbc on 22 Sep 2010 04:40:57 PM
how to subtract days!!we are using db2.
i want

difference(contract_maturity_date,etl_date) <= 120
these two are different columns containg dates
how will i give this filter.plz help
Title: Re: I want help in sql part in the filter!!!!!!!!!!!
Post by: cognostechie on 22 Sep 2010 05:12:19 PM
_days_between(contract_maturity_date,etl_date) <= 120
Title: Re: I want help in sql part in the filter!!!!!!!!!!!
Post by: katdbc on 23 Sep 2010 09:37:35 AM
Thank you so much!!!!
i used some thing similar like
_add_days(exp,numeric day which u wanna add)

thanks ppl fr ur views
Text only | Text with Images