Column data auto update

[Jacky_Lam]

Hi all,

I am working on a database of products with expiry dates. What I am trying to achieve is to have a column name "Status" to show whether the product is "Valid" or "Expired", and the column can auto update the status to "Expired" when it passes the expiry date. Anyone has an idea on this?

[Joseph_Seddik · Accepted solution]

You can have a virtual column with the following app formula:

IF(TODAY() > [date], "Expired", "Valid")

[graham_howe]

Use a virtual column with an expression that compares today's date with the expiry date. Something like

If(today() > [expiry date], "Expired", "Valid)