"Calculating the difference in minutes between the current time and a given time."

[Bracha]

I'm trying to calculate the minute difference between two times
and get an empty field

.........base search here.........
|end_time = 2024-09-24 08:17:13.014337+00:00
|eval end_time = strptime(end_time_epoch, "%Y:%m:%d %H:%M:%S")
|eval _time = now()
|eval time_epoch = strptime(time_epoch, "%Y:%m:%d %H:%M:%S")
|eval diff = (time_epoch-end_time)/60

[inventsekar · Accepted solution]

Hi @Bracha Pls check this:

| makeresults | eval end_time="2024-09-24 08:17:13.014337+00:00"
|eval end_timeepoch = strptime(end_time, "%Y-%m-%d %H:%M:%S.%6Q+00:00")
|eval _time = now()
|eval diff = (end_timeepoch-_time)/60 | table end_time end_timeepoch _time diff

inventsekar_0-1728972499048.png

[Bracha]

thanks @inventsekar 

it solved!

[inventsekar]

@Bracha could you pls accept it as solution, thanks.