Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..??
Hi
'Q' & Pick(Num(Month(Invoice_Date)), 1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4)
HTH
Jonathan
Hi,
Try the following: 'Q' & ceil(num(month(Invoice_Date))/3) as Quarter
Hi,
try below
'Q'&ceil(month(TempDate)/3) AS Quarter
Replace TempDate with your date.
Regards
ASHFAQ
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
Hi,
also function QuarterName(Date)
QuarterName('02-01-2014') -> gen mar 2014
Regards,
Antonio