Convert date to quarter

I'm fairly new to crystal, and I have a crosstab that list columns by a date field, and groups the date by quarter. In the header of each column, crystal displays "1/2007 ..... 4/2007...... 7/2007..... etc (its displaying the first month of the quarter). I want to convert that header from the month/year to 1Q07......2Q07.....3Q07...etc, or something similar that identifies the quarter and year. Any ideas? I cant find a function and can't come up with forumula to do this. Im sure this is an easy question for most :)Create 2 formulas: the 1st one for the quarter and the second one to get your desired result:

1. @.Quarter

if month({table.date})<=3 then '1' else
if month({table.date})>=4 and month({table.date})<=6 then '2' else
if month({table.date})>=7 and month({table.date})<=9 then '3'
else '4'

// it's not necessary to place it in the report area
----
2. @.nQYY

{@.Quarter}+'Q'+right((totext(year({table.date}),0)),2)

Use this formula in your crosstab to list the columns by it, I mean instead of your {table.date} field.