How to do time math in script field

[Echo_yu]

Hi, I want to do some time math in script field of Kibana. Now I have a field called startdatetime with the data type of date, and a field called runtime with the data type of number, how can i sum them up and return a new field with the type of date? Please help me . Looking forward to your reply, THANKS!

[Liza_Katz]

Hi @Echo_yu

Painless easily supports such manipulations:
Try using something like this in your scripted field:

Instant.ofEpochMilli(doc['startdatetime'].value.getMillis() + doc['runtime'].value)

Good luck,
Liza
`

[Echo_yu]

It works correctly！Thank you so much！