# Kibana scripted fields
**URL:** https://discuss.elastic.co/t/kibana-scripted-fields/255930
**Category:** Kibana
**Tags:** painless
**Created:** [November 19, 2020, 6:39am UTC](https://discuss.elastic.co/t/kibana-scripted-fields/255930 "2020-11-19T06:39:59Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Gokul6](https://discuss.elastic.co/u/Gokul6)
#### Post date: [November 19, 2020, 6:40am UTC](https://discuss.elastic.co/t/kibana-scripted-fields/255930/1 "2020-11-19T06:40:00Z")
i am differentiating two date fields and getting the time in milliseconds as output. here is my code
if(!doc['confirmedAt'].empty)
{
return doc['confirmedAt'].value.getMillis() - doc['createdAt'].value.getMillis()
}
i want to divide this by 60000 so that i can get the time in minutes. i am unable to do this. please help me.
---
### Author:  [@nishant.saini](https://discuss.elastic.co/u/nishant.saini)
#### Post date: [November 19, 2020, 7:18am UTC](https://discuss.elastic.co/t/kibana-scripted-fields/255930/2 "2020-11-19T07:18:09Z")
> [@Gokul6](#):
>
> ```
> return doc['confirmedAt'].value.getMillis() - doc['createdAt'].value.getMillis()
>
> ```
Changing above to
```
return (doc['confirmedAt'].value.getMillis() - doc['createdAt'].value.getMillis())/60000
```
should work.
---
### Author:  [@Gokul6](https://discuss.elastic.co/u/Gokul6)
#### Post date: [November 19, 2020, 7:33am UTC](https://discuss.elastic.co/t/kibana-scripted-fields/255930/3 "2020-11-19T07:33:44Z")
i tried this method @nishant.saini but it is throwing an error saying "Script is invalid".
---
### Author:  [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [November 19, 2020, 4:06pm UTC](https://discuss.elastic.co/t/kibana-scripted-fields/255930/5 "2020-11-19T16:06:17Z")
I've never seen the use of `.empty` before, are you sure you don't want `.size()` to determine that the field exists? Here's the [walkthrough documentation](https://www.elastic.co/guide/en/elasticsearch/painless/7.10/painless-walkthrough.html).
---
### Author:  [@Gokul6](https://discuss.elastic.co/u/Gokul6)
#### Post date: [November 19, 2020, 4:43pm UTC](https://discuss.elastic.co/t/kibana-scripted-fields/255930/6 "2020-11-19T16:43:36Z")
hi @wylie !! thanks for helping out. is there a way to **subtract a date field from current time** using painless?? I used the below code to do so but it didn't work.
DateTime.now().getMillis() - doc['createdAt'].value
---
### Author:  [@wylie](https://discuss.elastic.co/u/wylie)
#### Post date: [November 19, 2020, 7:36pm UTC](https://discuss.elastic.co/t/kibana-scripted-fields/255930/7 "2020-11-19T19:36:08Z")
> **[Using Datetime in Painless | Painless Scripting Language \[master\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/painless/master/painless-datetime.html#_datetime_now)**
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 17, 2020, 7:36pm UTC](https://discuss.elastic.co/t/kibana-scripted-fields/255930/8 "2020-12-17T19:36:10Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.