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.
Software/Hardware used:
ASKED:
June 24, 2005 11:20 AM
UPDATED:
June 29, 2005 7:51 AM
Anytime I have date math I convert to Julian Date. Simple math, easy to work with, and in most languages a faster convert to/from than casting system date to variable.
Good luck.
p.s. Of course I have a roman numeral calculator also.
Couple of quick questions, what version of DB2 are you using? what development environment are you using? and what is the error message you get? If it is a parsing error then you probably aren’t dealing with just a date format issue at this point.