Forum Discussion

ThomasRingkamp's avatar
ThomasRingkamp
Qrew Member
5 years ago

How to extract Year from a Date Calculated Field

I have a Date Calculated Field called OSP Ready Date whose Formula is this: If([Construction Complete?]=true, Max([Coax Construction Task Completed Date],[Fiber Construction Task Completed Date],[Node...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
It appears that your field for Year is a date field type. Change it to a formula numeric field type.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
ThomasRingkamp's avatar
ThomasRingkamp
Qrew Member
5 years ago
Would the field still show as as Date in the Table or as as Number? I need it to show a Date

------------------------------
Thomas Ringkamp
------------------------------