{"action":"created","issue":{"url":"https://api.github.com/repos/frappe/frappe/issues/1719","repository_url":"https://api.github.com/repos/frappe/frappe","labels_url":"https://api.github.com/repos/frappe/frappe/issues/1719/labels{/name}","comments_url":"https://api.github.com/repos/frappe/frappe/issues/1719/comments","events_url":"https://api.github.com/repos/frappe/frappe/issues/1719/events","html_url":"https://github.com/frappe/frappe/pull/1719","id":149931781,"number":1719,"title":"Problem on ‘Created On’/'Last Updated On' filter","user":{"login":"ShashaQin","id":12147007,"avatar_url":"https://avatars.githubusercontent.com/u/12147007?v=3","gravatar_id":"","url":"https://api.github.com/users/ShashaQin","html_url":"https://github.com/ShashaQin","followers_url":"https://api.github.com/users/ShashaQin/followers","following_url":"https://api.github.com/users/ShashaQin/following{/other_user}","gists_url":"https://api.github.com/users/ShashaQin/gists{/gist_id}","starred_url":"https://api.github.com/users/ShashaQin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ShashaQin/subscriptions","organizations_url":"https://api.github.com/users/ShashaQin/orgs","repos_url":"https://api.github.com/users/ShashaQin/repos","events_url":"https://api.github.com/users/ShashaQin/events{/privacy}","received_events_url":"https://api.github.com/users/ShashaQin/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/frappe/frappe/labels/discussion","name":"discussion","color":"f7c6c7"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-04-21T01:28:10Z","updated_at":"2016-04-22T04:58:07Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/frappe/frappe/pulls/1719","html_url":"https://github.com/frappe/frappe/pull/1719","diff_url":"https://github.com/frappe/frappe/pull/1719.diff","patch_url":"https://github.com/frappe/frappe/pull/1719.patch"},"body":"Related to https://discuss.erpnext.com/t/problem-on-created-on-filter/11937.\r\nWe found there is a bug on 'Created On' filter on list view page. I found list data will not include the data whose creation is '2016-04-08' When I put filter Created On <= 2016-04-08. \r\nThe same problem will happen when using 'Equal', it will not get any data by using condition ifnull(`tabTime Log`.creation, \"\") = \"2016-04-08\".\r\n'Last Updated On' filter has same issue."},"comment":{"url":"https://api.github.com/repos/frappe/frappe/issues/comments/213256638","html_url":"https://github.com/frappe/frappe/pull/1719#issuecomment-213256638","issue_url":"https://api.github.com/repos/frappe/frappe/issues/1719","id":213256638,"user":{"login":"rmehta","id":140076,"avatar_url":"https://avatars.githubusercontent.com/u/140076?v=3","gravatar_id":"","url":"https://api.github.com/users/rmehta","html_url":"https://github.com/rmehta","followers_url":"https://api.github.com/users/rmehta/followers","following_url":"https://api.github.com/users/rmehta/following{/other_user}","gists_url":"https://api.github.com/users/rmehta/gists{/gist_id}","starred_url":"https://api.github.com/users/rmehta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rmehta/subscriptions","organizations_url":"https://api.github.com/users/rmehta/orgs","repos_url":"https://api.github.com/users/rmehta/repos","events_url":"https://api.github.com/users/rmehta/events{/privacy}","received_events_url":"https://api.github.com/users/rmehta/received_events","type":"User","site_admin":false},"created_at":"2016-04-22T04:58:07Z","updated_at":"2016-04-22T04:58:07Z","body":"Why not convert the value in to a timestamp object?"}}