# Timestamp range query **URL:** \ **Category:** Elasticsearch\ **Created:** [February 11, 2016, 10:00pm UTC](https://discuss.elastic.co/t/timestamp-range-query/41557 "2016-02-11T22:00:59Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![mc1392](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@mc1392](https://discuss.elastic.co/u/mc1392)\ **Post date:** [February 11, 2016, 10:00pm UTC](https://discuss.elastic.co/t/timestamp-range-query/41557/1 "2016-02-11T22:00:59Z")
My latest data is February 5th 2016, 13:18:10.036 to February 10th 2016, 20:00:19.590. This query doesnt work: curl -XGET [http://localhost:9200/member\_type\_history](http://localhost:9200/member_type_history) -d '{"query":{"filter":{"range":{"@timestamp":{"gt":"2016-02-05T13:18:10.036", "lt" : "2016-02-05T23:59:59.590"}}}}}' What am I doing wrong? The data is there. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [February 12, 2016, 1:44am UTC](https://discuss.elastic.co/t/timestamp-range-query/41557/2 "2016-02-12T01:44:03Z")
What is your mapping and can you show a doc which should match? ---
**Author:** ![mc1392](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@mc1392](https://discuss.elastic.co/u/mc1392)\ **Post date:** [February 12, 2016, 5:34pm UTC](https://discuss.elastic.co/t/timestamp-range-query/41557/3 "2016-02-12T17:34:25Z")
I run this command: `curl -XGET http://localhost:9200/member_type_history -d '{"query":{"filter":{"range":{"@timestamp":{"gt":"2016-02-05 00:00:00.000", "lt" : "2016-03-05 23:59:59.000"}}}}}'` And get this response: `{"member_type_history":{"aliases":{},"mappings":{"Member Type":{"properties":{"@timestamp":{"type":"date","format":"strict_date_optional_time||epoch_millis"},"@version":{"type":"string"},"ATSID":{"type":"string"},"Age":{"type":"long"},"DegreeDesignation":{"type":"string"},"Email":{"type":"string"},"Fax":{"type":"string"},"FirstName":{"type":"string"},"Gender":{"type":"string"},"HomePhone":{"type":"string"},"LastName":{"type":"string"},"Member Type":{"type":"string","index":"not_analyzed"},"MembershipExpireDate":{"type":"string"},"MiddleName":{"type":"string"},"NPINumber":{"type":"string"},"Phone":{"type":"string"},"RequestDoNotCall":{"type":"string"},"RequestDoNotEmail":{"type":"string"},"Salutation":{"type":"string"},"Suffix":{"type":"string"},"Title":{"type":"string"},"atsJoinDate":{"type":"string"},"atsJoinYear":{"type":"long"},"id":{"type":"string"},"type":{"type":"string"}}}},"settings":{"index":{"creation_date":"1454695858727","number_of_shards":"5","number_of_replicas":"1","uuid":"wi0l903pRg68jKXBvyDV5A","version":{"created":"2000099"}}},"warmers":{}}}` Here is a screen shot showing I have data for the stated time frame: ![](https://us1.discourse-cdn.com/elastic/original/2X/f/f3118e058bd48cc9212fc806aceca88d99b8fc8b.jpg) ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [February 12, 2016, 6:33pm UTC](https://discuss.elastic.co/t/timestamp-range-query/41557/4 "2016-02-12T18:33:14Z")
The second query is not the same as the first one. Why this? Then where is the sample document? Can't find it. ---
**Author:** ![mc1392](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@mc1392](https://discuss.elastic.co/u/mc1392)\ **Post date:** [February 12, 2016, 7:20pm UTC](https://discuss.elastic.co/t/timestamp-range-query/41557/5 "2016-02-12T19:20:42Z")
Yes, the query is different, but same purpose. Here is the JSON for a document: { "\_index": "member\_type\_history", "\_type": "Member Type", "\_id": "AVKyp9mo9RA4myKx5rpC", "\_score": null, "\_source": { "id": "0014000000PaOsyAAF", "NPINumber": null, "ATSID": "54545", "Salutation": "Dr.", "FirstName": "Joe", "MiddleName": null, "LastName": "Doe", "RequestDoNotEmail": "No", "Email": "email@net.com", "RequestDoNotCall": "No", "Phone": "27 333333", "HomePhone": null, "Fax": "23 44444", "Title": null, "Suffix": null, "DegreeDesignation": "MD", "Gender": "Male", "Age": 66, "Member Type": "Senior ATS Membership (International)", "MembershipExpireDate": "2016-02-21 00:00:00 +0000", "atsJoinYear": 1992, "atsJoinDate": null, "@version": "1", "@timestamp": "2016-02-05T18:18:10.036Z", "type": "Member Type" }, "fields": { "@timestamp": [ 1454696290036 ] }, "sort": [ 1454696290036 ] } Here is a screen shot of the document in Kibana: ![](https://us1.discourse-cdn.com/elastic/original/2X/d/dca9df8a3c8be3690fd924ade0f3e171560c171f.jpg) ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [February 12, 2016, 8:18pm UTC](https://discuss.elastic.co/t/timestamp-range-query/41557/6 "2016-02-12T20:18:33Z")
Which version? ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [February 12, 2016, 8:21pm UTC](https://discuss.elastic.co/t/timestamp-range-query/41557/7 "2016-02-12T20:21:24Z")
And can you reproduce your issue with a full script? Here it's hard to follow because you changed the query in the meantime. ---
**Author:** ![mc1392](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@mc1392](https://discuss.elastic.co/u/mc1392)\ **Post date:** [February 12, 2016, 10:09pm UTC](https://discuss.elastic.co/t/timestamp-range-query/41557/8 "2016-02-12T22:09:01Z")
ES is 2.0, Kibana is 4.2 ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [February 13, 2016, 7:22am UTC](https://discuss.elastic.co/t/timestamp-range-query/41557/9 "2016-02-13T07:22:06Z")
Ok. Can you reproduce it with a script? I'm not talking about Kibana here but only elasticsearch. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 5, 2017, 11:16pm UTC](https://discuss.elastic.co/t/timestamp-range-query/41557/10 "2017-07-05T23:16:38Z")