Convert date to quarter

[northtexasdude]

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 :)

[SvB_NY]

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.