Format view json not getting date format correct

Copper Contributor

 

The following Json formatting code gives me the incorrect row highlighting as seen below. Why and how to fix it please.
{
  "schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
  "additionalRowClass": "=if([$Order_x0020_Date]< [$Arrival_x0020_Date],'ms-fontColor-neutralSecondary ms-fontColor-redDark ms-fontSize-mPlus ms-fontWeight-bold sp-field-severity--blocked','')"
}

 

ApplicationFrameHost_Mf1dwbpo2o.png

4 Replies

@shanebekker 

 

Can you try the below?

 

{
    "schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
    "additionalRowClass": "=if( Date(toDateString([$Order_x0020_Date])) < Date(toDateString([$Arrival_x0020_Date])),'ms-fontColor-neutralSecondary ms-fontColor-redDark ms-fontSize-mPlus ms-fontWeight-bold sp-field-severity--blocked','')"
}

 

@Shreyansh Agrawal  Thanks for replying but I still get the same results
ApplicationFrameHost_Mf1dwbpo2o.png

@shanebekker 

 

Can you share the following details -

  1. Field type for Order Date & Arrival Date [Date or Calculated Date]
  2. Are you using SharePoint OnPrem or SharePoint Online

Hi,

 

Using sharepoint lists online and datetime fields