Does anyone know if Cognos supports using the oracle round function with a date? I tried adding a custom data item as follows:
round ([DATE], 'YEAR')
.. but I keep getting an error. The tips only show rounding to an integer value.
Have you tried using the EXTRACT function instead?
U can use - Extract ( date_name , Year ) or to_char( dat_name , 'YYYY') .
-Tarun
That's what I ended up using - thanks!