Query on date issue

Elastic Stack Elasticsearch
1

Hi,

I am experiencing an issue when query on date field. when indexing, I use North American/New York timezone, and query it with same timezone, but I still missing some records. anyone knows how to query on date file?

{
"bool": {
"should": [{
"bool": {
"must": [{
"range": {
"startDate": {
"from": "2018-05-30",
"to": "2018-05-30",
"include_lower": true,
"include_upper": true,
"time_zone": "America/New_York",
"format": "yyyy-MM-dd",
"boost": 1.0
}
}
}],
"disable_coord": false,
"adjust_pure_negative": true,
"boost": 1.0
}
}],
"disable_coord": false,
"adjust_pure_negative": true,
"boost": 1.0
}
}

thanks

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.