Forum Discussion

Tob_P's avatar
Tob_P
Helper 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

2 Replies

  • 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