select quarter

[Anonymous]

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,

[rohit214]

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

[Anonymous]

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,

[Anonymous · Accepted solution]

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.