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.

[Permanently Rejected] is a Date field type.

Current logic:

If(Date(2016,12,31)>=[Program approved] or Date(2016,12,31)>=[Permanently Rejected],"2016", "2017")
Formulas and functions
    • 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]))
      )