# Unsupported value - Simple Date format on Kibana
**URL:** https://discuss.elastic.co/t/unsupported-value-simple-date-format-on-kibana/164518
**Category:** Kibana
**Tags:** painless
**Created:** [January 16, 2019, 5:44pm UTC](https://discuss.elastic.co/t/unsupported-value-simple-date-format-on-kibana/164518 "2019-01-16T17:44:30Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@nyssac](https://discuss.elastic.co/u/nyssac)
#### Post date: [January 16, 2019, 5:44pm UTC](https://discuss.elastic.co/t/unsupported-value-simple-date-format-on-kibana/164518/1 "2019-01-16T17:44:30Z")
Hi all - I have a metric in my index that is in java.util.Date milliseconds, like this -\> 1,547,659,500,000
I want to convert this to a date format like this -\> January 16th 2019, 09:28:05.150
Can I do this with a painless script? If yes, how?
---
### Author:  [@nyssac](https://discuss.elastic.co/u/nyssac)
#### Post date: [January 16, 2019, 7:26pm UTC](https://discuss.elastic.co/t/unsupported-value-simple-date-format-on-kibana/164518/2 "2019-01-16T19:26:10Z")
I managed to create a painless script
if (doc['StartTime'].value != null) {
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'");
simpleDateFormat.setTimeZone(TimeZone.getTimeZone("UTC"));
return simpleDateFormat.format(new Date(doc['StartTime'].value));
}
return 0;
and this is returning ""2019-01-10T11:57:00.000Z" but Kibana is still complaining with an "Unsupported script value" error. Any ideas why?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 13, 2019, 7:37pm UTC](https://discuss.elastic.co/t/unsupported-value-simple-date-format-on-kibana/164518/3 "2019-02-13T19:37:47Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.