# Date, Scripted Fields

**URL:** <https://discuss.elastic.co/t/date-scripted-fields/263341>\
**Category:** Kibana\
**Created:** [February 5, 2021, 7:40am UTC](https://discuss.elastic.co/t/date-scripted-fields/263341 "2021-02-05T07:40:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rajasekhar\_Muthamset](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rajasekhar_muthamset/32/83460_2.png) [@Rajasekhar\_Muthamset](https://discuss.elastic.co/u/Rajasekhar_Muthamset)\
**Post date:** [February 5, 2021, 7:40am UTC](https://discuss.elastic.co/t/date-scripted-fields/263341/1 "2021-02-05T07:40:28Z")

</div>

Hello All,

I'm getting data as below from my application

....."extraParams":[{"name":"Item","value":"item1"},{"name":" **DateTime**","value":" **0001519156380000**"},....

I would like the data of the field value as Date instead of a string when the name data is 'DateTime'. I tried using the scripted field for this, but not working..

if doc['extraParams.name'].value == 'name' then  
retrun new Date(Long.parseLong(doc['extraParams.value'].value)

Any help or guidance would be appreciated.

---

<div class="post-metadata">

**Author:** ![Rajasekhar\_Muthamset](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rajasekhar_muthamset/32/83460_2.png) [@Rajasekhar\_Muthamset](https://discuss.elastic.co/u/Rajasekhar_Muthamset)\
**Post date:** [February 5, 2021, 6:23pm UTC](https://discuss.elastic.co/t/date-scripted-fields/263341/2 "2021-02-05T18:23:19Z")

</div>

I have made few changes to mapping '"store": true', and recreated the index. Now, the script works without an error, but not seeing value as expected.

I verified the source documents, and I see a field with date.

if (doc['extraParams.name.keyword'].value == "DateTime") {  
return new Date(Long.parseLong(doc["extraParams.value.keyword"].value));  
}

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [February 9, 2021, 12:44pm UTC](https://discuss.elastic.co/t/date-scripted-fields/263341/3 "2021-02-09T12:44:08Z")

</div>

What does it display with the current scripted field? the number **0001519156380000** as a string?

---

<div class="post-metadata">

**Author:** ![Rajasekhar\_Muthamset](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rajasekhar_muthamset/32/83460_2.png) [@Rajasekhar\_Muthamset](https://discuss.elastic.co/u/Rajasekhar_Muthamset)\
**Post date:** [February 9, 2021, 1:49pm UTC](https://discuss.elastic.co/t/date-scripted-fields/263341/4 "2021-02-09T13:49:06Z")

</div>

yeah, string.

I got it working. Thanks for responding.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 9, 2021, 1:49pm UTC](https://discuss.elastic.co/t/date-scripted-fields/263341/5 "2021-03-09T13:49:19Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.