shifted Quarter

[arsenal1983]

Hello,

I need to set into my data model new dimmenssion - shifted quarter. Normally quarter name looks like:

jan-mar 2013

apr-jun 2013

I need to create qtr shifted for 2 months:

mar 2013 - may 2013

jun 2013 - aug 2013

sep 2013 - nov 2013

dec 2013 - feb 2014

any suggestions?

[tresesco · Accepted solution]

QuarterName(YourDate, 0, 3)