SharePoint JSON Code Error

Question

I am getting the following error in one of my cells when I try to write my own code into SharePoint :

"Failure: Method Date.prototype.toLocaleString called on incompatible receiver [object Object]"

The following is my code:

{

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

"elmType": "div",

"debugMode": true,

"txtContent": "@currentField",

"attributes": {

"class": "= if(Number(@currentField) == 0, '' , if(@currentField< [$Date], 'sp-css-backgroundColor-blockingBackground50', ''))"

}

}

Answer 1

Hi @Ninx ,

Assuming that the "@currentField" and "[$Date]" are both Date and Time Column, then the Json Column formatting in the question is working as expected per my test:

@currentField( named "Test" for example):

[$Date]:

Thanks
Best Regards

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.