Calculate Year from date

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Hello,  I have a filed called Time Card Date and I want to create a report summarizing an entire Year.  So I created a new filed call TimeCard Year and made it a Formula - Date/time field type.  Then I used the formula Year([TiemCard Year])  I don't get anything showing up in the field.  Obviously I'm doing something wrong.  Any ideas? 

Photo of Chuck

Chuck

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 908 Points 500 badge 2x thumb
If you want to just show the year, the field type should be Formula-Numeric and the formula would be:

Year([Time Card Date])
Photo of Chuck

Chuck

  • 0 Points
That was perfect.  Thank you so much.