Forum Discussion

eenochs-turner's avatar
eenochs-turner
Brass Contributor
Apr 30, 2020

JSON Date Range Help

Is it possible using JSON to create a text color change based on a date range.  For example I have a field that shows when a warranty starts.  Warranty is good for a year.  I would like the text to c...
SharePoint Online
eenochs-turner's avatar
eenochs-turner
Brass Contributor
May 05, 2020

RobElliott 

 

Rob thank you for the response but i went a different route and I'm almost there.  This is the JSON command i went with and its working but now i have a issue with blank entries.  

 

{

  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

  "elmType": "div",

  "debugMode": true,

  "txtContent": "@currentField",

  "style": {

    "color": "=if([$EMR_x0020_Effective_x0020_Date] +31556952000 <= @now, '#ff0000', '#000000')"

  }

}

 

The Issue I'm having now is how can i add a statement to this to ignore any entry that is blank.  In this list there will be blank entries as not every item has a warranty period.  

Holman Gutierrez's avatar
Holman Gutierrez
Copper Contributor
Apr 06, 2021

eenochs-turner This works to change font color. How do I also change background color? Thank you.

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Apr 06, 2021

    Holman Gutierrez you add a comma after the previous line then add another line with
    "background-color": "#c00000"
    or whatever color you want.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

Resources