3 Replies Latest reply: Nov 23, 2011 1:57 PM by Vladimir Kostochka

# select quarter

Hi folk,

Please help me to find the issue to select current quarter and previous quarter in expression or however.

I calculate the quarter:

'Q' & Ceil(Month(date)/3)& '-' & year(date) as Quarter.

Thank you so much,

• ###### select quarter

hi vovan

why dont you write  'Q' & Ceil(Month(date)/3)& '-' & year(date) as Quarter.

means year(date)

and  'Q' & Ceil(Month(date)/3)

by doing this you can get information means at whish yaer and which quarter

thanks

rohit

• ###### select quarter

Ho rohit,

I don't know another way to get it.

In my case I get  Q1-2011, Q2-2011,Q3-2011, so on.

Could you suggest some else, I'll be appreciate it?

Thanks,

• ###### select quarter

I found out the issue.

In script:

QuarterName(QuarterStart(submitDateTime)) as QQQ

and in expresssion:

{<QQQ={'\$(=QuarterName(max(QQQ)))'}>}                        current quarter:

{<QQQ={'\$(=QuarterName(max(QQQ),-1))'}>}                    last quarter.