Skip to Content
Former Member
Nov 09, 2011 at 08:06 AM

Quarter Calculation in Transformation based on Billing Date



I need Quarter to be calculated based on the Billing date. I created a Z Characteristic & added it to my DSO, mapped Billing date (FKDAT) to this Z characteristic in Transformation. Then, I created a Formula in this mapping: Calculate Quarter from Day - DATE_QUARTER( FKDAT). When i load data, the Output i get is in the Format 20112 whereas i need in the Format 2011 Q2 or Q2 2011. I checked for a Standard formula for this but couldnt find anything.

Please let me know if there is any standard formula or routine to achieve this in Transformation.

I have also searched for this scenario in this Forum but didnt find anything useful.