Using the Oracle ROUND function with dates

[cognos_guru]

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.

[jmwhite]

Have you tried using the EXTRACT function instead?

[imts]

U can use - Extract ( date_name , Year ) or to_char( dat_name , 'YYYY') .

-Tarun

[cognos_guru]

That's what I ended up using - thanks!