DATE to financial quarter

[Anonymous]

I have a date field column

date format for this column is -

                                              01-07-2001

                                              26-09-2011

i want to convert it into financial quarter-

output like -Q2

                 Q3

[MayilVahanan]

Hi,

     Try this,

     = 'Q' & Ceil(Month(Date) / 3)

     or

    = Dual('Q' & Ceil(Month(Date) / 3) & ' ' & Year(Date), QuarterName(Date))

     Hope it helps

[Anonymous]

no.

i want to make apr-june-   Q1

                      july-sep     Q2

like in this way

[Anonymous]

quarter 4

[Anonymous]

2012 apr-jun -Q1

.....

.....

2013 jan-mar-Q4

[#6 · Accepted solution]

Use this:

'Q'&If(Month(QuarterStart(Datefield))='1',4,Div(Month(QuarterStart(Datefield)),3))

Kiran.

[MayilVahanan]

Hi,

Its give

'Q'&If(Month(QuarterStart(Date))='1', 4, Div(Month(QuarterStart(Date)),3)) as Quarter

As Kiran said..

[Anonymous]

Hi,

you are right . i am new here can you explain it littlebit if you don't mind.

Month(QuarterStart(OrderDate)) as mm,--jul

Div(Month(QuarterStart(OrderDate)),3) as no_mm,--02

If(Month(QuarterStart(OrderDate))='1',4,Div(Month(QuarterStart(OrderDate)),3))

i want to know how is it executing

regards

[#9]

QuarterStart would return month beginning for each quarter as in calendar like jan=1, apr =4 etc.. Used if else to change 1 to 4 and div to find the quotient while dividing with 3 for the rest.

Regards,

Kiran Rokkam.

[Anonymous]

thanks