I need to write the filter condition in cognos as follows:
YRMOSDOS between (&YRMOSDOS - 200) AND (&YRMOSDOS)
where YRMOSDOS is in date form. How do I achieve it?
The database is in db2. Decimal function does not work.
Please help. Thanks a lot.
June 24, 2005 11:20 AM
June 29, 2005 7:51 AM