To_Char on Crystal DateTime Field for formatting

[get2work]

In Oracle, we use the following format to create a field that can be grouped by:
TO_CHAR(V_PIN_TRACK_MAPPING.ACTIVATED_DATE, 'MM/YYYY')

In Crystal, however, this formula:
TO_CHAR({V_PIN_TRACK_MAPPING.ACTIVATED_DATE}, 'MM/YYYY')
sends back an error "The remaining text does not appear to be part of the formula".

The field is stored in a DD-MON-YY HH24:MI:SS format.

How should this formula be typed in?

Thanks for any help!

 

[synapsevampire]

You don't need to convert a date field to group on it, but this is how you could address a to_char:

Crystal does not use to_char, so you could either create a SQL Expression (depending upon your Crystal version):

Insert->Fioeld Object->Right click SQL Expression and select New, then add in:

TO_CHAR(V_PIN_TRACK_MAPPING.ACTIVATED_DATE, 'MM/YYYY')

Now you can use this field in the report as you might any other field.

Within Crystal you might create a formula (as in the above only select New on Formula Fields)

totext({V_PIN_TRACK_MAPPING.ACTIVATED_DATE},"MM/yyyy&quot

-k

 

[get2work]

Thanks! I chose the latter formula using totext. This partially works. I get 07/YYYY instead of 07/2003. I've tried using formula with the single tick marks and the double quote marks with the same results.
Because the datetimestamp in this field is unique for 100K+ records, I need to group by the month and year.
Any sugguestions for why I am receiving the following 07/YYYY? I'm using Crystal Reports v8.5. Thanks for your response.

 

[synapsevampire]

Use lowercase, my example uses lowercase y's, you used uppercase.

-k

 

[get2work]

THANK YOU!!!