Statement formatting

[Tob_P]

Hi there,

Can someone advise how I can rectify this statement please? If the agreement end date is in this year, then I want the custom column to display 'Active', otherwise 'Inactive'.

[Anonymous · Accepted solution]

(pay attention to case sensitivity)

= if Date.IsInCurrentYear([Agreement End Date]) then "Active" else "Inactive

--Nate

[Tob_P]

Thank you very much @Anonymous