Query on Date field from Grafana vs Kibana

Grafana Elasticsearch
1

Wondering why this query on a Date type, which returns hits in Kibana, doesn’t return hits in Grafana.

Any hints appreciated, TIA!

08
081595×1062 241 KB

2

I think your Lucene query is not correct.
In my case, this is working
NOT candidate.status: "Screened" AND candidate.create_date:["now-30d" TO "now"]

maybe it is important, that your date field has format ‘YYYY-MM-DDThh:mm:ss’. Here the T is important
Maybe in Kibana the Lucene query or the date format do not have to be so strict.