Daylight Savings Time with only weekday and time range

[agruttner]

Hi All,

We're trying to index some date ranges that only use a weekday and time, and running into issues with daylight savings time.

For example if we have the following mapping:

"properties": {
  "time": {
    "type": "date_range",
    "format": "E HH:mm ZZZ"
  }
}

And a document like:

{
    "time" : {
      "gte": "Monday 10:00 America/Los_Angeles",
      "lt": "Monday 20:00 America/Los_Angeles"
    }
}

We would want this query to match during daylight savings but not after:

{
  "query": {
    "term": {
      "time": "Monday 17:00 UTC"
    }
  }
}

Is there a way to do this with elasticsearch?

We tried changing the date format to E HH:mm ZZZ || YYYY-MM-DD HH:mm ZZZ but including the year/month/day in the query doesn't match any documents indexed using only weekday+time.

Thanks in advance!