Employment Contract Status. will be Active or Expired

[Ahmad_1]

New user - I'm trying to do this is I have a 'Contract Status' column which will show 'ACTIVE' or 'EXPIRE' and the column rule will be automatically updated on our calendar date today.
this expression
IF (([EXPIRATION DATE] <TODAY () + 1), "Expired", "Active")
I want how to do it

[WillowMobileSys · Accepted solution]

It looks like you have the correct expression - mostly:

IF ([EXPIRATION DATE] < TODAY() + 1, "Expired", "Active")

Next you need a Virtual Column so that the Status is checked and automatically updated on any Syncs to the app.

Create the Virtual Column of type Enum and name it "Contract Status".  If you already have a column in your table then give this new column a slightly different name but it will be this virtual column you use in the app.

Edit the Column and add the enum values of "ACTIVE" and "EXPIRE". 

Add the above expression into the "App Formula" property. 

Done.