Quarter format for Q1- 2011-12

[#1]

Hi,

I need a quarter function format like "Q1 2011-12 " like this i need.

Help needed.

Regards,

Madhukumara

[Anonymous]

dateuse  (exp for quarter) &'-'& year(date )&'-'& day(date)

[jagannalla]

Hello,

try this

'Q' & Ceil(Month(DateField)/3) & '-' & Year(DateField)& '-' & Day(DateField) AS CalendarQuarterAndYear

Hope it helps you.

Cheers!

[kaushalview]

Hi

Try this expression.

='Q'&ceil(month('2012-02-12')/3)&'-'&Yearname('2012-02-12',0,4)

='Q'&ceil(month('2012-02-12')/3)&'-'&Year('2012-02-12')&'-'&Day('2012-02-12')

Regards

Kaushal Mehta

[#5]

need quarter format like  Q1-2011-12 (Q1-yyyy-yy)

                                      Q1-2012-13(Q1-yyyy-yy)

[rajni_batra]

'Q' & Ceil(Month(DateField)/3) & '-' & Yearname(DateField) AS Quarter_Year

[#7]

for ur expression i am getting Q1-2011...

i need as Q1-2011-2012, Q2-2012-2013 (Q1-yyyy-yyyy)

[jagannalla · Accepted solution]

Hello,

Try this code i think your looking for this solution only.

LOAD 'Q' & Ceil(Month(DateField)/3) & '-' & Year(DateField)& '-' & Year(YearEnd(DateField,1)) AS QCYrNyr

Hope it helps you.

Cheers !

[#9]

Thanks Jagan