Date comparison check

Elastic Stack Kibana
1

I have a date format
"2018-03-29T08:02:17-05:00" (ISO 8601, no fractional seconds)

However, the below query returns zero records:

filters
| esdocs index="index_1*" fields="fields.Sprints.name.keyword, fields.Sprints.endDate"
| alterColumn "fields.Sprints.name.keyword" name="issues"
| alterColumn "fields.Sprints.endDate" name="endDate"
| filterrows fn={getCell "endDate" | gte value="date"}
| math "unique(issues)"

I think gte is not working above as expected. But, it returns correct result if lte used. Is there any way I can do the above comparison and display the date in DD-MMM-YY format in a table

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.