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]))
  • 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]))
    )

  • StephenAnguiano's avatar
    StephenAnguiano
    Qrew Cadet
    8 years ago
    Thank you that worked great.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Thx for letting me know.!