Forum Discussion

AdmiralS's avatar
AdmiralS
Copper Contributor
May 11, 2020

JSON for Formatting Dates

I currently have a SharePoint list that we use for tracking Insurance Policy Expiration dates.  I would like it to format with the warning format for dates that are within the next 30 days.  I have r...
Lists
SharePoint Online
Vikram_Samal's avatar
Vikram_Samal
MCT
May 11, 2020

AdmiralS I will share the simpler approach just use this that will help. I have also shown below the example I made for you.

This is the formula: You need to convert the days in to millisecond to compare. 30 days is 2592000000 milliseconds.

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "color": "=if([$ExpiryDate]<= @now+2592000000, '#ff0000', '')"
  }
}

Hopefully this helps and mark the response appropriately.

AdmiralS's avatar
AdmiralS
Copper Contributor
May 11, 2020

Thanks!

 

I need to color for 3 scenarios against the same column though -

 

Red - Dates Before Today

Yellow- Dates between Today and 30 days out

Green - Dates 30 days and forward from Today

 

Can I do that all in the same JSON conditional filter?

  • Vikram_Samal's avatar
    Vikram_Samal
    MCT
    May 11, 2020

    AdmiralS Yes just you have to use multiple Ifs I have shown an example which can follow and modify as per your need.

    This is the code:

    {
   "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
   "elmType": "div",
   "txtContent": "@currentField",
   "style": {
      "color": "=if([$Color] == 'Red', 'red', if([$Color] == 'Green', 'green',if([$Color] == 'Blue', 'Blue', if([$Color] == 'Yellow', 'Yellow', 'Orange'))))"
   }
}

    Hope this helps mark the response appropriately if it helps to solve your problem.

Resources