Discussions

Expand all | Collapse all

Need help updating current logic for capturing ""Year"".

  • 1.  Need help updating current logic for capturing ""Year"".

    Posted 01-17-2018 17:02

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


  • 2.  RE: Need help updating current logic for capturing ""Year"".

    Posted 01-17-2018 17:19
    The function

    Year([my date]) will return a numeric value like 2018


  • 3.  RE: Need help updating current logic for capturing ""Year"".

    Posted 01-17-2018 17:27
    So I can write the logic like so to get year:


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


  • 4.  RE: Need help updating current logic for capturing ""Year"".

    Posted 01-17-2018 17:32
    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]))
    )



  • 5.  RE: Need help updating current logic for capturing ""Year"".

    Posted 01-18-2018 14:01
    Thank you that worked great.


  • 6.  RE: Need help updating current logic for capturing ""Year"".

    Posted 01-18-2018 14:07
    Thx for letting me know.!