This changes the background colour according to date + milliseconds *** CHANGE THE TITLE – LAST LINE
Red – within today <= 30 days
Orange – today plus 31 days -> 90 days
Yellow – 91 days -> 180 Days
Black – More than today Plus 180
_____________________________________________________________________________
{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”,
“elmType”: “div”,
“style”: {
“box-sizing”: “border-box”,
“padding”: “0 2px”,
“overflow”: “hidden”,
“text-overflow”: “ellipsis”,
“font-weight” : “bold”,
“background-color”: “=if(@currentField <= @now + 2592000000, ‘red’,if(@currentField <= @now + 7776000000 && @currentField > @now + 2592000000,’orange’,if(@currentField <= @now + 15552000000 && @currentField > @now + 7776000000,’yellow’,’green’)))”
},
“txtContent”: “[$BOSIET_x002f_FOET.displayValue]”
}
