Calculated Field Date Formatting

Occasional Visitor

Hello,

 

I have a calculated date/time field which for the past year has been working without issue however recently the formatting has stopped working.

 

It should look like the below (and it does temporarily after changing the formula and changing it back)

DanE31_0-1647443212477.png

but recently it reverts to look like 

DanE31_1-1647443249837.png

 

Here's the JSON I used:

{

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

  "elmType": "div",

  "debugMode": true,

  "txtContent": "@currentField",

  "style": {

    "padding": "0 5px",

    "background-color": "=if(@currentField < @now, '#ff0000', '#007d00')",

    "color": "#FFFFFF"

  }

}

 

Co-incidentally we also have an integrated PowerApps form with this Sharepoint list which when a form is submitted takes about 30 seconds to a minute to visually update in the list where before it was instant.

 

Does anyone have any idea what could be causing these issues?

 

Cheers,

Dan

0 Replies
www.000webhost.com