Date fields comparison

[g_k_b]

Hi There!
I would desire to create a scripted field comparing 2 date fields in Kibana, in particular:
I want to use current date ( new Date().getTime() ) and a date field I indexed already (named expiring date). The comparison I want to do is something like :"if current date is more recent than expiring date return working, if not return expired.

This syntax:
new Date().getTime() > doc['expiting date'].value
doesn't work.

Could anyone help me please? Thanks in advance!

[AClerk]

There are dozens of examples out there.
Here are a couple of them -->

Calculate Difference between 2 Dates in Scipted Field

Hi All, I am trying to create a new scripted field by calculating the difference(in seconds) between 2 date in the following format ` October 15th 2018, 22:15:27.823 The two fields I am using are start_time and end_time. I have tried various method covering both Painless and expression as language. Every time I try I get different error. Example:- if(!doc['end_time'].empty) { return doc['end_time'].value - doc['start_time'].value } Error it gave is:- "caused_by":{"type":"parse_except…

Kibana time delta between two fields

Kibana painless- Difference in dates in days

I have two date fields - Date1 and Date2, both are in date format I want to calculate days between the two dates. I tried doc['date2'].value - doc['date1'].value, this is not giving the expected return value

[g_k_b]

Thank you, I read already something similar to that since, as you say, there are dozens of similar topics. The very aim of my request is to create a kind of gantt diagram in Kibana, or something similar to it. I was wondering to create a proper date field as an escamotage to reach my point, but if you guys have a "more direct" suggestion for me, tell me