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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!