DateTime 1

[JonathanNYC]

I have a field "pcm.surgdate"(DateTime) thatI would like to show in the report only by calendar year.

For example, I want 12/18/2006 to show as 2006 and 2/15/2004 to show as 2004, etc.

I am using Crystal Reports 10.0. Might someone recommend a formula that I might use.

 

[KeertanaCR]

YEAR({pcm.surgdate}) will give year part of the date

Thankyou
Keerthana

 

[JonathanNYC]

Thanks Keerthana, most appreciated.

 

[lbass]

You don't even need a formula. If you go to format field->date->customize->set month to "None" and day to "None".

-LB