Hi,

I have a calculated column . I want to show only year from date of created column.  for example created date is 01/01/2015 , I need to show 2015 in calculated column.

How I can add condition for this column in view ?

do you see any better approach without using view ?

Thanks,

This would do it;

=IF(Created="","",""&YEAR(Created)) 

Are you asking how you'd filter by this in a view?

Hi ,

You can use calculated column and use the formula

RIGHT([Created],LEN([Created])-INT(FIND("/",[Created])))

Hi Nikhil0041,

Based on your description, you want to extract year from Created column.

Here are some suggestions:

1. Click library settings.
2. Choose the column you want to edit.
3. Add the formula below to the formula section.

Formula=IF(Created="","",""& TEXT(Created,"yyyy"))

You can also use the formula provided by Jamie McAllister:

=IF(Created="","",""&YEAR(Created))

Best Regards,