"Friendly" date display format combine with custom json formatting

Ian Bruckner 

Hi,

I know, this is an old thread, but answering it in case other people are struggling with this. To achieve this have txtContent value as [$ColumnInternalName.displayValue] not @currentField. For example, my full code is as follows for the column AppSecretExpiration.

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