What about using a display format on the client?

M/YYYY should do it.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Tony " <apatri@...>
To: <IBObjects@egroups.com>
Sent: Monday, January 15, 2001 7:26 AM
Subject: [IBO] EXTRACT YEAR FROM A DATE FIELD IN COMPUTED FIELDS


> Hi All.
>
> There is a way to extract only Year from a field?
> This should be performed in a computed fields.
>
> EG
> the computed field 'd show : 1/2001
>
> so let's say:
> I have a field named COUNTER and another named TRY_DATE:
> The computed field is made by:
>
> COUNTER || CAST( TRY_DATE AS VARCHAR( 10 ))
>
> but show me : 1/2001-01-15.
> I wanna only: 1/2001.
>
> TIA
> Tony
>
>
>
>