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")