Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a date format like 201901, 201902, 201903....201801,201802....so on. I wanted Year, Month ans Quarter Field. I was able to extract Year and Month field. But how to do for Quarter? How to do that. Please suggest.
This gave me Year and Month Field
left( "Year Month",4) as Year,
Right( "Year Month",2) as Month,
Year-month Year Month Quarter
201901 2019 01
201902 2019 02
201903 2019 03
201801 2018 01
201803 2018 03
201807 2018 07
Please suggest!
Regards,
Niha
Awesome Sunny!
Try this
'Q' & Ceil(Num(Right( "Year Month", 2))/3) as Quarter
Awesome Sunny!