Forum Discussion

StephenAnguiano's avatar
StephenAnguiano
Qrew Cadet
8 years ago

Need help updating current logic for capturing ""Year"".

Need help updating current logic to account for 2018 projects is there an easier way to capture year no matter what the month or day is? [Program approved] is a formula ? text field type. ...
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
The function

Year([my date]) will return a numeric value like 2018
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
well that exact formula would not work as a text formula field type

But this would

IF(
not IsNull([Program approved]), ToText(Year([Program approved])),
not IsNull([Program Rejected]), ToText(Year([Program Rejected]))
)