Subtraction between current date and doc created date

[PappuSingh (Pappu Kumar Singh)]

Hi,
Please see the below code sample.

long l1=(new Date().getTime());
//emit(l1);
long l= ChronoUnit.SECONDS.between(l1, doc['timestamp'].value);
if(l<=100000){
emit('New')
}
else{emit('Old')}

I am getting the below Error

Cannot cast from [long] to [java.time.temporal.Temporal]. Verify that you have correctly set the runtime field type.

[stephenb (Stephen Brown)]

Hi @PappuSingh Welcome to the community.

Perhaps this will help it is nearly the same use case.

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]

[PappuSingh (Pappu Kumar Singh)]

How I can calculate hours or day?

Please see my code below
long datenow = new Date().getTime();

long datewas = doc['createdTime'].value.getMillis();

long milisecondnd=datenow - datewas;

long second=milisecondnd/1000;

long hours=second/3600;

long daycount=hours/24;

emit(daycount);

the wrong Number is displaying it is showing 1

CreatedTime="Jan 21, 2023 @ 01:29:06.500"

[stephenb (Stephen Brown)]

Do you want Days in Integer or Float?

Field Type Double

long datenow = new Date().getTime();
long datewas = doc['@timestamp'].value.getMillis();
double days = (datenow - datewas) / 86400000.0;
emit (days);

Field Type Long

long datenow = new Date().getTime();
long datewas = doc['@timestamp'].value.getMillis();
long days = (datenow - datewas) / 86400000;
emit (days);

[PappuSingh (Pappu Kumar Singh)]

Thank you it is working now.