# Kibana Visualization Error using scripted Date field

**URL:** <https://discuss.elastic.co/t/kibana-visualization-error-using-scripted-date-field/235874>\
**Category:** Kibana\
**Created:** [June 5, 2020, 2:02am UTC](https://discuss.elastic.co/t/kibana-visualization-error-using-scripted-date-field/235874 "2020-06-05T02:02:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sanjaysubramanian](https://avatars.discourse-cdn.com/v4/letter/s/bcef8e/32.png) [@sanjaysubramanian](https://discuss.elastic.co/u/sanjaysubramanian)\
**Post date:** [June 5, 2020, 2:02am UTC](https://discuss.elastic.co/t/kibana-visualization-error-using-scripted-date-field/235874/1 "2020-06-05T02:02:18Z")

</div>

I have a scripted Date field (called "yyyy\_mm\_dd") in Kibana 7.7.0

**Script**

```auto
Date date = new Date(doc['ts'].value.millis); 
Calendar cal = Calendar.getInstance();
cal.setTime(date);
cal.set(Calendar.HOUR_OF_DAY, 0);
cal.set(Calendar.MINUTE, 0);
cal.set(Calendar.SECOND, 0);
cal.set(Calendar.MILLISECOND, 0);
return cal.getTime();

```

When I try to build an Aggregation using "Date Histogram" in Kibana and select "yyyy\_mm\_dd" as the field , I get errors. The Kibana logs are not very elaborate

```auto
error [02:00:15.308] Error: Internal Server Error
    at HapiResponseAdapter.toError (kibana-7.7.0-darwin-x86_64/src/core/server/http/router/response_adapter.js:130:19)
    at HapiResponseAdapter.toHapiResponse (kibana-7.7.0-darwin-x86_64/src/core/server/http/router/response_adapter.js:84:19)
    at HapiResponseAdapter.handle (kibana-7.7.0-darwin-x86_64/src/core/server/http/router/response_adapter.js:79:17)
    at Router.handle (kibana-7.7.0-darwin-x86_64/src/core/server/http/router/router.js:162:34)
    at process._tickCallback (internal/process/next_tick.js:68:7)

```

---

<div class="post-metadata">

**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\
**Post date:** [June 12, 2020, 4:23pm UTC](https://discuss.elastic.co/t/kibana-visualization-error-using-scripted-date-field/235874/2 "2020-06-12T16:23:20Z")

</div>

Hi, do you have any error on the browser console? if so could you post that error?  
Can you please also post also the response error?  
I've tested locally and seems that is a missing date casting somewhere.  
A temporary workaround is to change the scripted field to return the date in millis like

```auto
return cal.getTimeInMillis();

```

could you please also open a GH issue for that? [https://github.com/elastic/kibana/issues/new?template=Bug\_report.md](https://github.com/elastic/kibana/issues/new?template=Bug_report.md)

Thanks so much

---

<div class="post-metadata">

**Author:** ![sanjaysubramanian](https://avatars.discourse-cdn.com/v4/letter/s/bcef8e/32.png) [@sanjaysubramanian](https://discuss.elastic.co/u/sanjaysubramanian)\
**Post date:** [June 15, 2020, 1:43am UTC](https://discuss.elastic.co/t/kibana-visualization-error-using-scripted-date-field/235874/3 "2020-06-15T01:43:00Z")

</div>

@markov00  
Hi Marco  
Sorry for the delay in my response. I have attached the screen shot of the error displayed in the Kibana web console when I use the scripted field as the "date field" in the Date Histogram

 ![Screen Shot 2020-06-14 at 6.32.43 PM](https://us1.discourse-cdn.com/elastic/original/3X/8/5/850f39277c0f46f128d0f5cbcd01b9a4c109f564.png) ![Screen Shot 2020-06-14 at 6.32.24 PM](https://us1.discourse-cdn.com/elastic/original/3X/7/5/75c7e1b78ad511cea9c9ce1cd75ec18d29830c2b.png)

Thanks for your recommendation for using **return cal.getTimeInMillis();**. You idea worked beautifully. Thank you , thank you, thank you !

---

<div class="post-metadata">

**Author:** ![sanjaysubramanian](https://avatars.discourse-cdn.com/v4/letter/s/bcef8e/32.png) [@sanjaysubramanian](https://discuss.elastic.co/u/sanjaysubramanian)\
**Post date:** [June 15, 2020, 1:58am UTC](https://discuss.elastic.co/t/kibana-visualization-error-using-scripted-date-field/235874/4 "2020-06-15T01:58:09Z")

</div>

@markov00  
Hi Marco

I logged a ticket as per your request

> <https://github.com/elastic/kibana/issues/69121>
>
> Kibana version:
> 7.1.0
> Elasticsearch version:
> 7.7.0
> Server OS version:
> macOS Catalina 10.15.4 (19E287)
> Browser version:
> Google Chrome Version 83.0.4103.61 (Official Build) (64-bit)
> Browser OS version:
> Original install method (e.g. download...

Thanks for your help

sanjay

---

<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:** [July 13, 2020, 1:58am UTC](https://discuss.elastic.co/t/kibana-visualization-error-using-scripted-date-field/235874/5 "2020-07-13T01:58:13Z")

</div>

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