Converting a string date (epoch) to a Date field using scripted fields in kibana

Elastic Stack Kibana
1

Hi!

I have a date in the form of a string (epoch) like below:

"1553012442470"

Now I want to use scripted fields in kibana to convert the string date time to a date field.

Also perform multiple operations with the field on the date, for example, subtract these two dates and choose the days of difference

How can I go about it?

2

Is there any reason you wouldn't want to do this at ingest time instead of after the fact with a scripted field?

3

Lukas,
When indexing the data we indicate the date Epoch is the _id
I can not reindex the data and change the mapping

4 
return new Date(Long.parseLong(doc["_id.keyword"].value));
5

Thanks Lukas! :sonriendo:

6

Thanks Lukas! :sonriendo: