Kibana 7.5.1 - calculating user's AGE by using Scripted Field

Elastic Stack Kibana
1

hey guys,

this is my script (found it online), unfortunately it keeps returning "0".

Field Type:
Number

Script:
return Period.between (
doc['@timestamp'].value.toLocalDate(), Instant.ofEpochMilli(System.currentTimeMillis()).atZone(doc['@timestamp'].value.getZone()).toLocalDate() ).getYears()

do you have any idea why?

2

This is simpler way of figuring out what you want to find out (basically the number of years between current date and timestamp).

return System.currentTimeMillis() - doc["@timestamp"].value.getMillis()

And change the format to Duration and it will show it in years as well.