Dec.31

Get year of created date in a calculated column

If you need to extract year from created value, just create new column  and use the following formula:

 

=DATE(YEAR([Created]),1,1)

 

New column should be single text in order to use its value in views and filters, because date format is not supported.

Share this Story:
  • facebook
  • twitter
  • gplus

Leave a comment