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
StephenAnguiano's avatar
StephenAnguiano
Qrew Cadet
8 years ago
So I can write the logic like so to get year:


If(Year([Program approved]) or Year([Permanently Rejected]))