Group By Date ( Year Month) in Cognos 8 Report Studio

[newyork66]

I have a date field, it's format in DB like this 'mm/dd/yyyy'. How do I group by by YEAR -Month in Report Studio?

[MFGF]

Hi,

Add two query calculations
extract([yourdateitem],year)
extract([yourdateitem],month)
Then group on these calculations.

Regards,

MF.

[newyork66]

 :D Great it works. Thank you!