interval in month

[manoranjan_d]

hi all,

like interval 0-10,10-20, i want to get the month in interval example jan-mar, apr-june, july-sep, oct-dec

how to do in the coding and i want to use this as dimension in the bar chart

[zhadrakas]

do you Need exactly this names?

You can calculate Quarters of the year to achieve this:

'Q'&ceil(month(TempDate)/3) AS Quartal,

regards

tim