Loading

ES|QL TO_DATE_RANGE function

Converts a value to a date_range.

Embedded
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