Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
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
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,
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.