# Elasticsearch query with @timestamp range
**URL:** https://discuss.elastic.co/t/elasticsearch-query-with-timestamp-range/97469
**Category:** Elasticsearch
**Created:** [August 17, 2017, 6:45pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timestamp-range/97469 "2017-08-17T18:45:18Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Dee](https://discuss.elastic.co/u/Dee)
#### Post date: [August 17, 2017, 6:45pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timestamp-range/97469/1 "2017-08-17T18:45:18Z")
Hi,
What am I doing wrong in my query? I'm getting response:
"reason" : "failed to parse date field [August 17th 2017, 21:59:28.000] with format [strict\_date\_optional\_time||epoch\_millis]",
"caused\_by" : {
"type" : "illegal\_argument\_exception",
"reason" : "Invalid format: "August 17th 2017, 21:59:28.000""
}
My query looks like this:
```
curl -XPOST 'localhost:9200/_all/_search?pretty' -d '
{
"query": {
"bool": {
"must": {
"match": {
"host": "hostname"
}
},
"filter": {
"range": {
"@timestamp": {
"gte": "August 17th 2017, 21:59:28.000"
}
}
}
}
}
}'
```
My @timestamp field in kibana also looks like this. Using epoch time works.
Thanks!
---
### Author:  [@Dee](https://discuss.elastic.co/u/Dee)
#### Post date: [August 17, 2017, 7:28pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timestamp-range/97469/2 "2017-08-17T19:28:28Z")
Found a solution, elasticsearch is expecting iso format ("2017-08-17T21:59:28") which worked.
Thanks,
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 14, 2017, 7:28pm UTC](https://discuss.elastic.co/t/elasticsearch-query-with-timestamp-range/97469/3 "2017-09-14T19:28:36Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.