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

I want help in sql part in the filter!!!!!!!!!!!

Started by katdbc, 22 Sep 2010 04:40:57 PM

Previous topic - Next topic

katdbc

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

cognostechie

_days_between(contract_maturity_date,etl_date) <= 120

katdbc

Thank you so much!!!!
i used some thing similar like
_add_days(exp,numeric day which u wanna add)

thanks ppl fr ur views