JSON date and time column
Hey guys
I’ve been using a JSON from GitHub for a simple date and time column.
it’s been working perfectly and showing all the correct dates, but recently it’s started to display the wrong dates.
can anybody tell me how I can fix this? So in my SharePoint list the end user enters the date 12/10/2024 but it will display as 13/10/2024
here’s the JSON:
{ “$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json“, “elmType”: “div”, “style”: { “flex-direction”: “column”, “width”: “50px”, “margin”: “5px”, “display”: “=if(@currentField,’flex’,’none’)” }, “children”: [ { “elmType”: “div”, “txtContent”: “=getYear(@currentField)”, “style”: { “margin”: “2px” }, “attributes”: { “class”: “ms-fontColor-themePrimary ms-fontWeight-bold” } }, { “elmType”: “div”, “forEach”: “weekday in split(‘0,1,2,3,4,5,6′,’,’)”, “style”: { “white-space”: “nowrap” }, “attributes”: { “class”: “ms-fontColor-themePrimary ms-fontWeight-bold” }, “children”: [ { “elmType”: “div”, “txtContent”: “=if([$weekday]==’0′,’Saturday’,if([$weekday]==’1′,’Sunday’,if([$weekday]==’2′,’Monday’,if([$weekday]==’3′,’Tuesday’,if([$weekday]==’4′,’Wednesday’,if([$weekday]==’5′,’Thursday’,if([$weekday]==’6′,’Friday’,”))))))”, “style”: { “margin-bottom”: “2px”, “display”: “=if((getMonth(@currentField)+1)>2,if(((getDate(@currentField)+floor(26*(getMonth(@currentField)+1+1)/10)+Number(substring(toString(getYear(@currentField)),2,4))+floor(Number(substring(toString(getYear(@currentField)),2,4))/4)+floor(Number(substring(toString(getYear(@currentField)),0,2))/4)-2*Number(substring(toString(getYear(@currentField)),0,2)))%7)==Number([$weekday]),”,’none’),if(((getDate(@currentField)+floor(26*(getMonth(@currentField)+1+12+1)/10)+Number(substring(toString(getYear(@currentField)-1),2,4))+floor(Number(substring(toString(getYear(@currentField)-1),2,4))/4)+floor(Number(substring(toString(getYear(@currentField)-1),0,2))/4)-2*Number(substring(toString(getYear(@currentField)-1),0,2)))%7)==Number([$weekday]),”,’none’)” } } ] }, { “elmType”: “div”, “txtContent”: “=if(getMonth(@currentField)==0,’Jan’,if(getMonth(@currentField)==1,’Feb’,if(getMonth(@currentField)==2,’Mar’,if(getMonth(@currentField)==3,’Apr’,if(getMonth(@currentField)==4,’May’,if(getMonth(@currentField)==5,’Jun’,if(getMonth(@currentField)==6,’Jul’,if(getMonth(@currentField)==7,’Aug’,if(getMonth(@currentField)==8,’Sep’,if(getMonth(@currentField)==9,’Oct’,if(getMonth(@currentField)==10,’Nov’,if(getMonth(@currentField)==11,’Dec’,”))))))))))))”, “style”: { “display”: “flex”, “justify-content”: “center”, “align-items”: “center”, “width”: “100%”, “height”: “20px”, “border”: “1px solid”, “margin-bottom”: “-1px” }, “attributes”: { “class”: “ms-bgColor-themePrimary ms-fontColor-white ms-borderColor-themePrimary ms-fontWeight-bold” } }, { “elmType”: “div”, “txtContent”: “=getDate(@currentField)”, “style”: { “display”: “flex”, “justify-content”: “center”, “align-items”: “center”, “width”: “48px”, “border”: “1px solid”, “height”: “30px” }, “attributes”: { “class”: “ms-fontColor-themePrimary ms-borderColor-themePrimary ms-fontWeight-bold ms-fontSize-20” } } ] }
Hey guys I’ve been using a JSON from GitHub for a simple date and time column. it’s been working perfectly and showing all the correct dates, but recently it’s started to display the wrong dates. can anybody tell me how I can fix this? So in my SharePoint list the end user enters the date 12/10/2024 but it will display as 13/10/2024 here’s the JSON: { “$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”, “elmType”: “div”, “style”: { “flex-direction”: “column”, “width”: “50px”, “margin”: “5px”, “display”: “=if(@currentField,’flex’,’none’)” }, “children”: [ { “elmType”: “div”, “txtContent”: “=getYear(@currentField)”, “style”: { “margin”: “2px” }, “attributes”: { “class”: “ms-fontColor-themePrimary ms-fontWeight-bold” } }, { “elmType”: “div”, “forEach”: “weekday in split(‘0,1,2,3,4,5,6′,’,’)”, “style”: { “white-space”: “nowrap” }, “attributes”: { “class”: “ms-fontColor-themePrimary ms-fontWeight-bold” }, “children”: [ { “elmType”: “div”, “txtContent”: “=if([$weekday]==’0′,’Saturday’,if([$weekday]==’1′,’Sunday’,if([$weekday]==’2′,’Monday’,if([$weekday]==’3′,’Tuesday’,if([$weekday]==’4′,’Wednesday’,if([$weekday]==’5′,’Thursday’,if([$weekday]==’6′,’Friday’,”))))))”, “style”: { “margin-bottom”: “2px”, “display”: “=if((getMonth(@currentField)+1)>2,if(((getDate(@currentField)+floor(26*(getMonth(@currentField)+1+1)/10)+Number(substring(toString(getYear(@currentField)),2,4))+floor(Number(substring(toString(getYear(@currentField)),2,4))/4)+floor(Number(substring(toString(getYear(@currentField)),0,2))/4)-2*Number(substring(toString(getYear(@currentField)),0,2)))%7)==Number([$weekday]),”,’none’),if(((getDate(@currentField)+floor(26*(getMonth(@currentField)+1+12+1)/10)+Number(substring(toString(getYear(@currentField)-1),2,4))+floor(Number(substring(toString(getYear(@currentField)-1),2,4))/4)+floor(Number(substring(toString(getYear(@currentField)-1),0,2))/4)-2*Number(substring(toString(getYear(@currentField)-1),0,2)))%7)==Number([$weekday]),”,’none’)” } } ] }, { “elmType”: “div”, “txtContent”: “=if(getMonth(@currentField)==0,’Jan’,if(getMonth(@currentField)==1,’Feb’,if(getMonth(@currentField)==2,’Mar’,if(getMonth(@currentField)==3,’Apr’,if(getMonth(@currentField)==4,’May’,if(getMonth(@currentField)==5,’Jun’,if(getMonth(@currentField)==6,’Jul’,if(getMonth(@currentField)==7,’Aug’,if(getMonth(@currentField)==8,’Sep’,if(getMonth(@currentField)==9,’Oct’,if(getMonth(@currentField)==10,’Nov’,if(getMonth(@currentField)==11,’Dec’,”))))))))))))”, “style”: { “display”: “flex”, “justify-content”: “center”, “align-items”: “center”, “width”: “100%”, “height”: “20px”, “border”: “1px solid”, “margin-bottom”: “-1px” }, “attributes”: { “class”: “ms-bgColor-themePrimary ms-fontColor-white ms-borderColor-themePrimary ms-fontWeight-bold” } }, { “elmType”: “div”, “txtContent”: “=getDate(@currentField)”, “style”: { “display”: “flex”, “justify-content”: “center”, “align-items”: “center”, “width”: “48px”, “border”: “1px solid”, “height”: “30px” }, “attributes”: { “class”: “ms-fontColor-themePrimary ms-borderColor-themePrimary ms-fontWeight-bold ms-fontSize-20” } } ] } Read More