Extracting Only Year Value in Crystal Report DateTime Field

Here I have done with this way, my string was "01/02/2012 10:45:22Am"

after using this formula:

Formula = ToText({report_;1.FirstYearDate}, "yyyy")

I have got this value :2012

try this way

Year(Cdatetime(<<your date time value here>>));

Try this

Year (DateValue ({Orders.Order Date}))

Here for example date field is Order date from Orders table.

Related