Quarters

[kevbrown]

To change a date to month i can use the function

date(monthstart(ukmpsmr_risk.INCEPTION_DATE),'MMM-YY')

But how to I change a date to a Quarter?  I've got

date(QuarterName(ukmpsmr_risk.INCEPTION_DATE),'MMM-YY')

But that returns the quarter start month so Jan-14, I want Qtr 1

[rubenmarin]

you can use:

='Qtr ' & Ceil(Month(ukmpsmr_risk.INCEPTION_DATE)/4)

[tresesco]

See: Calculating quarters

[rubenmarin · Accepted solution]

My bad english, if quarter is a 3-month period then it will be:

='Qtr ' & Ceil(Month(ukmpsmr_risk.INCEPTION_DATE)/3)

[kevbrown]

superb, thanks.