{"action":"created","issue":{"url":"https://api.github.com/repos/SharePoint/sp-dev-docs/issues/3129","repository_url":"https://api.github.com/repos/SharePoint/sp-dev-docs","labels_url":"https://api.github.com/repos/SharePoint/sp-dev-docs/issues/3129/labels{/name}","comments_url":"https://api.github.com/repos/SharePoint/sp-dev-docs/issues/3129/comments","events_url":"https://api.github.com/repos/SharePoint/sp-dev-docs/issues/3129/events","html_url":"https://github.com/SharePoint/sp-dev-docs/issues/3129","id":391914397,"node_id":"MDU6SXNzdWUzOTE5MTQzOTc=","number":3129,"title":"Conditional formatting based on calculated field is broken since summer 2018","user":{"login":"hazymat","id":7063284,"node_id":"MDQ6VXNlcjcwNjMyODQ=","avatar_url":"https://avatars1.githubusercontent.com/u/7063284?v=4","gravatar_id":"","url":"https://api.github.com/users/hazymat","html_url":"https://github.com/hazymat","followers_url":"https://api.github.com/users/hazymat/followers","following_url":"https://api.github.com/users/hazymat/following{/other_user}","gists_url":"https://api.github.com/users/hazymat/gists{/gist_id}","starred_url":"https://api.github.com/users/hazymat/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hazymat/subscriptions","organizations_url":"https://api.github.com/users/hazymat/orgs","repos_url":"https://api.github.com/users/hazymat/repos","events_url":"https://api.github.com/users/hazymat/events{/privacy}","received_events_url":"https://api.github.com/users/hazymat/received_events","type":"User","site_admin":false},"labels":[{"id":427067663,"node_id":"MDU6TGFiZWw0MjcwNjc2NjM=","url":"https://api.github.com/repos/SharePoint/sp-dev-docs/labels/area:docs","name":"area:docs","color":"5319e7","default":false},{"id":1126353242,"node_id":"MDU6TGFiZWwxMTI2MzUzMjQy","url":"https://api.github.com/repos/SharePoint/sp-dev-docs/labels/area:list-formatting","name":"area:list-formatting","color":"e99695","default":false}],"state":"open","locked":false,"assignee":{"login":"thechriskent","id":8364109,"node_id":"MDQ6VXNlcjgzNjQxMDk=","avatar_url":"https://avatars0.githubusercontent.com/u/8364109?v=4","gravatar_id":"","url":"https://api.github.com/users/thechriskent","html_url":"https://github.com/thechriskent","followers_url":"https://api.github.com/users/thechriskent/followers","following_url":"https://api.github.com/users/thechriskent/following{/other_user}","gists_url":"https://api.github.com/users/thechriskent/gists{/gist_id}","starred_url":"https://api.github.com/users/thechriskent/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thechriskent/subscriptions","organizations_url":"https://api.github.com/users/thechriskent/orgs","repos_url":"https://api.github.com/users/thechriskent/repos","events_url":"https://api.github.com/users/thechriskent/events{/privacy}","received_events_url":"https://api.github.com/users/thechriskent/received_events","type":"User","site_admin":false},"assignees":[{"login":"thechriskent","id":8364109,"node_id":"MDQ6VXNlcjgzNjQxMDk=","avatar_url":"https://avatars0.githubusercontent.com/u/8364109?v=4","gravatar_id":"","url":"https://api.github.com/users/thechriskent","html_url":"https://github.com/thechriskent","followers_url":"https://api.github.com/users/thechriskent/followers","following_url":"https://api.github.com/users/thechriskent/following{/other_user}","gists_url":"https://api.github.com/users/thechriskent/gists{/gist_id}","starred_url":"https://api.github.com/users/thechriskent/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thechriskent/subscriptions","organizations_url":"https://api.github.com/users/thechriskent/orgs","repos_url":"https://api.github.com/users/thechriskent/repos","events_url":"https://api.github.com/users/thechriskent/events{/privacy}","received_events_url":"https://api.github.com/users/thechriskent/received_events","type":"User","site_admin":false}],"milestone":null,"comments":4,"created_at":"2018-12-17T22:21:46Z","updated_at":"2018-12-19T01:40:10Z","closed_at":null,"author_association":"NONE","body":"At some unknown point, approximately August 2018, I had a sharepoint online list whose column formatting stopped working. The column formatting was based on a calculated field (where both the reference and the calculated columns are Date and Time type).\n\nPart of the column formatting expression worked, that is the part that evaluates whether there is a value (and if so, apply a green background), however the nested condition that looks to see whether the date is approaching in the next three days, colouring the background red, stopped working.\n\nI have reproduced the problem described above using a new Date and Time column, as well as a column using calculated value based on the first. The formatting only works on the original, not the calculated column.\n\nThis previously worked. Is it a new 'feature'?\n\n---\n#### Document Details\n\n⚠ *Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.*\n\n* ID: f60068c3-4534-a400-350b-fdbcefd684b6\n* Version Independent ID: 228accdb-a7de-0671-34ad-60a37866c380\n* Content: [Use column formatting to customize SharePoint](https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting)\n* Content Source: [docs/declarative-customization/column-formatting.md](https://github.com/SharePoint/sp-dev-docs/blob/master/docs/declarative-customization/column-formatting.md)\n* Product: **sharepoint**\n* GitHub Login: @spdevdocs\n* Microsoft Alias: **spdevdocs**"},"comment":{"url":"https://api.github.com/repos/SharePoint/sp-dev-docs/issues/comments/448438088","html_url":"https://github.com/SharePoint/sp-dev-docs/issues/3129#issuecomment-448438088","issue_url":"https://api.github.com/repos/SharePoint/sp-dev-docs/issues/3129","id":448438088,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0ODQzODA4OA==","user":{"login":"iamguptarishi","id":8044005,"node_id":"MDQ6VXNlcjgwNDQwMDU=","avatar_url":"https://avatars0.githubusercontent.com/u/8044005?v=4","gravatar_id":"","url":"https://api.github.com/users/iamguptarishi","html_url":"https://github.com/iamguptarishi","followers_url":"https://api.github.com/users/iamguptarishi/followers","following_url":"https://api.github.com/users/iamguptarishi/following{/other_user}","gists_url":"https://api.github.com/users/iamguptarishi/gists{/gist_id}","starred_url":"https://api.github.com/users/iamguptarishi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/iamguptarishi/subscriptions","organizations_url":"https://api.github.com/users/iamguptarishi/orgs","repos_url":"https://api.github.com/users/iamguptarishi/repos","events_url":"https://api.github.com/users/iamguptarishi/events{/privacy}","received_events_url":"https://api.github.com/users/iamguptarishi/received_events","type":"User","site_admin":false},"created_at":"2018-12-19T01:40:10Z","updated_at":"2018-12-19T01:40:10Z","author_association":"NONE","body":"@thechriskent It seems that the calculated columns are broken. I tried to debug it and found that the Valid date time columns are converting date properly but with calculated columns its not converting date property as sub-string method is giving error. Not sure if this \"  var l = a[0] + \".calculated\";\" is intentionally added to the code. See the screen shots for more details.\r\n![dateerror](https://user-images.githubusercontent.com/8044005/50193554-edb2d100-02eb-11e9-8b55-079c0ccd79a1.png)\r\n"}}
{"actor":{"display_login":"iamguptarishi"}}