YYYYMM to Quarter-Year

[#1]

Hi,

need to convert the below to quarter-Year

201501

201502

201503

expected result: Q1-2015 and so on

any ideas?

Kind Regards,

Olle

[antoniotiman · Accepted solution]

='Q'&Ceil(right('201501',2)/3)&'-'&Left('201501',4)   -> Q1-2015