{"action":"opened","issue":{"url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/964","repository_url":"https://api.github.com/repos/salesagility/SuiteCRM","labels_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/964/labels{/name}","comments_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/964/comments","events_url":"https://api.github.com/repos/salesagility/SuiteCRM/issues/964/events","html_url":"https://github.com/salesagility/SuiteCRM/issues/964","id":134019352,"number":964,"title":"Reports - date calculations involving now don't work","user":{"login":"emcrobert","id":4323531,"avatar_url":"https://avatars.githubusercontent.com/u/4323531?v=3","gravatar_id":"","url":"https://api.github.com/users/emcrobert","html_url":"https://github.com/emcrobert","followers_url":"https://api.github.com/users/emcrobert/followers","following_url":"https://api.github.com/users/emcrobert/following{/other_user}","gists_url":"https://api.github.com/users/emcrobert/gists{/gist_id}","starred_url":"https://api.github.com/users/emcrobert/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/emcrobert/subscriptions","organizations_url":"https://api.github.com/users/emcrobert/orgs","repos_url":"https://api.github.com/users/emcrobert/repos","events_url":"https://api.github.com/users/emcrobert/events{/privacy}","received_events_url":"https://api.github.com/users/emcrobert/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-02-16T15:57:02Z","updated_at":"2016-02-16T15:57:02Z","closed_at":null,"body":"When you create a report if you add a condition with a date + or - a certain time from now it generates an invalid SQL query error \" Unknown column 'NOW' in 'where clause'\". \r\n\r\nThis should be NOW(), seems the code for stripping empty paragraphs from logic is too hungry!"}}