ES|QL TO_DATE_RANGE function
Converts a value to a date_range.
field-
Input value. The input can be a single- or multi-valued column or an expression.
Converts an input value to a date_range value. A string will be parsed as a date range in the format start..end, where start and end are dates in ISO format. The range is half-open [start, end).
| field | result |
|---|---|
| date_range
|
date_range |
| keyword | date_range |
| text | date_range |
ROW str = "2020-01-01T00:00:00.000Z..2021-01-01T00:00:00.000Z"
| EVAL range = TO_DATE_RANGE(str)
| str:keyword | range:date_range |
|---|---|
| 2020-01-01T00:00:00.000Z..2021-01-01T00:00:00.000Z | 2020-01-01T00:00:00.000Z..2021-01-01T00:00:00.000Z |