Forum Discussion
120 days before a date format row red backgorund and white text
Hi How can i format a sharepoint column so the whole row turns red and text is white. I want to get a warning with a red row 120 days before the value in "startdate" is equal to todays date ...
Hi oskarkuus
this should do the trick. In the sample the date field name is mydate.
{
"additionalRowClass": "=if(toString([$mydate]) == '', '', if(([$mydate]>@now), '', if((@now-[$mydate]) <= 10368000000, 'sp-css-backgroundColor-BgRed sp-field-fontSizeSmall sp-css-color-WhiteText', '')))"
}
10368000000 = 120 days converted to miliseconds
Regards