I am looking to create a calculated column that will trigger the word "expired" in another column if the date is less then or equal to today's date. Do you know what formula I would use for this?
1
-
or use column validation in the same column without using a calculated column.– vier111Jul 5, 2017 at 17:15
Add a comment
|
1 Answer
It is not supported by MS to use the current date in a calculated field. You should look for another approach. You can try with JSlink.
I think this can help you: Change the color of a row when Date >= today's date
answered Jul 5, 2017 at 17:45
Juan Pablo Pussacq LabordeJuan Pablo Pussacq Laborde
3,3691 gold badge15 silver badges24 bronze badges