{"action":"created","issue":{"url":"https://api.github.com/repos/elastic/elasticsearch-net/issues/1538","labels_url":"https://api.github.com/repos/elastic/elasticsearch-net/issues/1538/labels{/name}","comments_url":"https://api.github.com/repos/elastic/elasticsearch-net/issues/1538/comments","events_url":"https://api.github.com/repos/elastic/elasticsearch-net/issues/1538/events","html_url":"https://github.com/elastic/elasticsearch-net/issues/1538","id":102988661,"number":1538,"title":"Datetime Range search","user":{"login":"shoushouleb","id":13929075,"avatar_url":"https://avatars.githubusercontent.com/u/13929075?v=3","gravatar_id":"","url":"https://api.github.com/users/shoushouleb","html_url":"https://github.com/shoushouleb","followers_url":"https://api.github.com/users/shoushouleb/followers","following_url":"https://api.github.com/users/shoushouleb/following{/other_user}","gists_url":"https://api.github.com/users/shoushouleb/gists{/gist_id}","starred_url":"https://api.github.com/users/shoushouleb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shoushouleb/subscriptions","organizations_url":"https://api.github.com/users/shoushouleb/orgs","repos_url":"https://api.github.com/users/shoushouleb/repos","events_url":"https://api.github.com/users/shoushouleb/events{/privacy}","received_events_url":"https://api.github.com/users/shoushouleb/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":10,"created_at":"2015-08-25T09:42:28Z","updated_at":"2015-08-27T06:57:13Z","closed_at":"2015-08-26T17:25:49Z","body":"Hi \r\nI am trying to search for datetime ( from -> to) in boolean query, \r\nfor testing now,I am trying just to get the greater than\r\nand this is my query:\r\n<code>\r\n\r\n\r\n    lstDoc = elastic.Search<Document>(s => s\r\n                     .From(From)\r\n                     .Size(Size)\r\n                     .Query(q => q\r\n                         .Bool(a => a.Must(b =>\r\n                             b.Term(\"Document.lstChildren.AttributeValueID\",1)\r\n    && q.Range(n => n.GreaterOrEquals(Convert.ToDateTime( input),\"dd/MM/yyyy\").OnField( f=> f.Modified))\r\n                                 )// MUST\r\n                      )// bool\r\n                        \r\n                        ));\r\n\r\n</code>\r\n\r\n\r\nthe input is 25/08/2015 and I do have this value set to all my docs ( 9 docs) but the search always return no results."},"comment":{"url":"https://api.github.com/repos/elastic/elasticsearch-net/issues/comments/135315466","html_url":"https://github.com/elastic/elasticsearch-net/issues/1538#issuecomment-135315466","issue_url":"https://api.github.com/repos/elastic/elasticsearch-net/issues/1538","id":135315466,"user":{"login":"shoushouleb","id":13929075,"avatar_url":"https://avatars.githubusercontent.com/u/13929075?v=3","gravatar_id":"","url":"https://api.github.com/users/shoushouleb","html_url":"https://github.com/shoushouleb","followers_url":"https://api.github.com/users/shoushouleb/followers","following_url":"https://api.github.com/users/shoushouleb/following{/other_user}","gists_url":"https://api.github.com/users/shoushouleb/gists{/gist_id}","starred_url":"https://api.github.com/users/shoushouleb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shoushouleb/subscriptions","organizations_url":"https://api.github.com/users/shoushouleb/orgs","repos_url":"https://api.github.com/users/shoushouleb/repos","events_url":"https://api.github.com/users/shoushouleb/events{/privacy}","received_events_url":"https://api.github.com/users/shoushouleb/received_events","type":"User","site_admin":false},"created_at":"2015-08-27T06:57:13Z","updated_at":"2015-08-27T06:57:13Z","body":"SOLVED:\r\nRemove the mapping from the index creation.\r\nAdd mapping to the propert as = dd/MM/yyyy\r\nThe index will index the fields as 2015-01-01T00:00:00 so I pass the date value in the form of 2015-01-01\r\n\r\nThanks for your help"}}