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

[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.