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

[cis4life (Cedric Gaines)]

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.

Thanks,

[dadoonet (David Pilato)]

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:

Issue with date format change while reindexing

Here is a way to do it: POST _ingest/pipeline/_simulate { "pipeline" :{ "description": "date pipeline ", "processors": [ { "script": { "source": """ SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); ctx.person.birthDate = format.format(format.parse(ctx.person.birthDate)); """ } } ]}, "docs": [ { "_index": "index", "_type": "_doc", "_id": "id", "_source": { "person":…

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