How to pass in `current_unix_time` as a value for elasticsearch query?

[stephenb (Stephen Brown)]

Hi @learningelastic

Let's back up a bit

@learningelastic

"How many days have passed since [today]"

I am confused what you are actually trying to accomplish....

Are you trying to calculate the number of days from Today / Now with respect to a date field in the document?

@learningelastic

I understand that I can NOT put in a unix time as part of my painless

I am not sure where that understanding comes from...

Perhaps you are looking to do something like this

Calculate elapsed time in Kibana?

Hi @TXBigDawg1836 Welcome to the community Yup add a runtime field to the Data View here is the code long datenow = new Date().getTime(); long datewas = doc['@timestamp'].value.getMillis(); emit (datenow - datewas); Create / Set the Field [Screen Shot 2022-10-13 at 1.23.42 PM] Chose your format.... [Screen Shot 2022-10-13 at 1.23.54 PM] In Discover [Screen Shot 2022-10-13 at 1.34.19 PM] Now Table... [Screen Shot 2022-10-13 at 1.26.49 PM]