Forum Discussion

Tob_P's avatar
Tob_P
Icon for Helper V rankHelper V
2 years ago
Solved

Statement formatting

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'.   ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    (pay attention to case sensitivity)

     

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

     

    --Nate

Anonymous's avatar
Anonymous
Not applicable
2 years ago

(pay attention to case sensitivity)

 

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

 

--Nate

Tob_P's avatar
Tob_P
Icon for Helper V rankHelper V
2 years ago

Thank you very much Anonymous