Skip to main content
Question

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")
    This topic has been closed for replies.

    The function

    Year([my date]) will return a numeric value like 2018
    Terms & ConditionsAccessibility statement