If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to get Quarter from Datereceived column

Started by jd, 12 Mar 2010 10:39:39 AM

Previous topic - Next topic

jd

Hi all

I have date Received column in report studio report.
I am trying to get the year/quarter/month from that column. I am able to get year and Month using extract function.
ex: extract (Year,[Date Received])
extract (month,[Date Received])

I got stuck with quarter. Above function is not working for the quarter. Anybody have any idea hwo to get quarter from the Datereceived column.

Thanks,

CognosAdmn

how about using an if-then-else function

if (month in ('jan','feb','mar')) then ('Q1')
else if (month in ('apr','may','jun')) then ('Q2')
etc....