title: Use column formatting to customize SharePoint
body: <p>I'm following this article:
  <a href="https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#formatting-items-based-on-arbitrary-dates-advanced" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#formatting-items-based-on-arbitrary-dates-advanced</a></p>
  
  <p>I have an SP List with Renewal Date and would like to be it marked if the date is smaller than today-31 days so I modified the example from the article to:</p>
  
  <pre><code>{
    "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
    "elmType": "div",
    "txtContent": "@currentField",
    "style": {
      "color": "=if([$Renewal_x0020_Date] &lt;= @now - 2678400000‬, '#ff0000', '')"
    }
  }
  </code></pre>
  
  <p>So, according to "to add a day to a date, you'd add (24*60*60*1000 = 86,400,000)" I multiply this by 31.</p>
  
  <p>Unfortunately, the JSON doesn't format my view.</p>
  
  <p>Could someone direct me, please?</p>
  
  <p>Thanks</p>
  
  <p>Slawek</p>