QUarter: how to create by date

[#1]

LOAD date(Invoice_Date,'DD/MM/YYYY') as Invoice_Date,

Year(Invoice_Date) as Year,

Month(Invoice_Date) as Month,

QuarterName(Invoice_Date) as Quarter,

How to create a quarter like Q1, Q2..??

[jonathandienst]

Hi

'Q' & Pick(Num(Month(Invoice_Date)), 1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4)

HTH

Jonathan

[mvanlutterveld]

Hi,

Try the following: 'Q' & ceil(num(month(Invoice_Date))/3) as Quarter

[ashfaq_haseeb]

Hi,

try below

'Q'&ceil(month(TempDate)/3) AS Quarter

Replace TempDate with your date.

Regards

ASHFAQ

[#5]

Hi Sandeep,

Use the below statement:

LOAD date(Invoice_Date,'DD/MM/YYYY') as Invoice_Date,

Year(Invoice_Date) as Year,

Month(Invoice_Date) as Month,

'Q'  & ceil(month(Invoice_Date)/3) as Quarter,

Thanks

Sabal

[antoniotiman]

Hi,

also function QuarterName(Date)

QuarterName('02-01-2014') -> gen mar 2014

Regards,

Antonio