Forum Discussion

TonyGonzalez's avatar
TonyGonzalez
Qrew Trainee
11 days ago
Solved

Year Formula help

Simplest formula out there.  

Year([Date]) - It works in the formula checker, but nothing is showing up in my table in the Year field.  What could be causing this?

 

 

formulas
  • MikeTamoush's avatar
    MikeTamoush
    11 days ago

    Based off the yellow highlight, looks like you have the wrong type of field. The year extracted is a number, so should be a formula numeric field. 

2 Replies

Sort By
  • MikeTamoush's avatar
    MikeTamoush
    Qrew Commander
    11 days ago

    Based off the yellow highlight, looks like you have the wrong type of field. The year extracted is a number, so should be a formula numeric field. 

    • TonyGonzalez's avatar
      TonyGonzalez
      Qrew Trainee
      10 days ago

      Oh geesh.  How simple.  I had it as Formula Date because I consider Year a date.  But, your reasoning makes sense and of course, it worked.  thanks, Mike.