i try to create a new scripted field by calculating the difference(in minitues) between 2 dates in the following format :
bookingStatus.confirmed :Jan 22, 2020 @ 12:20:00.000
bookingStatus.wating :Jan 20, 2020 @ 10:20:00.000
i like the result be like : Xdays ,Xhours, Xminutes
in this case duration = 2 days , 2 hours ,0minutes
i try this expression but i don't get the correct result:
doc['bookingStatus.confirmed'].value.getMillis() - doc['bookingStatus.wating'].value.getMillis()
any help please !