Query on where a date field is Tuesday, Wednesday or Thursday

Good Day,

I have a field in my documents named 'measurement_timestamp' and I want to query it where that timestamp is on either Tuesday, Wednesday or Thursday. I know its possible, but can't find just a straight kinda of answer and example. I'm using the latest docker version of ES. Any kind of insight would greatly be appreciated.


The best thing to do is to compute this day of the week field at index time.
You can do that with a Painless processor I think.

I wrote an example here:

It's not computing the day of the week though but that should be easy to adapt.

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