# Scripted date field returns Invalid date
**URL:** https://discuss.elastic.co/t/scripted-date-field-returns-invalid-date/82980
**Category:** Kibana
**Created:** [April 20, 2017, 5:27am UTC](https://discuss.elastic.co/t/scripted-date-field-returns-invalid-date/82980 "2017-04-20T05:27:07Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@elasticheart](https://discuss.elastic.co/u/elasticheart)
#### Post date: [April 20, 2017, 5:27am UTC](https://discuss.elastic.co/t/scripted-date-field-returns-invalid-date/82980/1 "2017-04-20T05:27:07Z")
Hi,
I am using ELK GA 5.0.0. I have a field `logtime`, which contains date and time, and I would like to create a scripted field containing only time (or date), for that I made a `Date` scripted field showing the time alone. The settings are like below;
```
Language -> Painless
Type -> Date
Format -> Date
moment.js format pattern -> HH:mm:ss
Popularity -> 0
Script ->
def dateFormat = new SimpleDateFormat("HH:mm:ss");
return dateFormat.format(doc['logtime'].value);
```
What I am trying to accomplish is to get a field with value like `23:59:59`, but I am getting an error in Discover, like `Invalid date` for date field. How can I fix this?
Thanks in advance..
---
### Author:  [@GautamP](https://discuss.elastic.co/u/GautamP)
#### Post date: [April 20, 2017, 9:23am UTC](https://discuss.elastic.co/t/scripted-date-field-returns-invalid-date/82980/2 "2017-04-20T09:23:30Z")
An alternate solution to creating a scripted field would be to go the `Management` tab and change the format of the desired field in the respective index.
Here is a screenshot:
Change the `Format` from `-default-` to `Date`.
Change `moment.js format pattern` to the desired pattern.
---
### Author:  [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)
#### Post date: [April 20, 2017, 8:25pm UTC](https://discuss.elastic.co/t/scripted-date-field-returns-invalid-date/82980/3 "2017-04-20T20:25:48Z")
You're getting an error because `23:59:59` is actually a string, not a date. So you'll have to change the type to "string".
Thanks,
CJ
---
### Author:  [@elasticheart](https://discuss.elastic.co/u/elasticheart)
#### Post date: [April 21, 2017, 12:11pm UTC](https://discuss.elastic.co/t/scripted-date-field-returns-invalid-date/82980/4 "2017-04-21T12:11:46Z")
Hi @cjcenizal agrred. But, if I make it a "string", will I be able to pick it as date histogram (first column in my table visualization) and sort my table based on that?
---
### Author:  [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)
#### Post date: [April 21, 2017, 3:21pm UTC](https://discuss.elastic.co/t/scripted-date-field-returns-invalid-date/82980/5 "2017-04-21T15:21:46Z")
Oh, good point. I don't think that will work, though it might be worth trying it out and making sure. Have you tried Gautam's solution?
---
### Author:  [@elasticheart](https://discuss.elastic.co/u/elasticheart)
#### Post date: [April 22, 2017, 6:59pm UTC](https://discuss.elastic.co/t/scripted-date-field-returns-invalid-date/82980/6 "2017-04-22T18:59:50Z")
Hi @cjcenizal , I don't think that's applicable, because I have some line charts, which needs HH:mm:s. 😞
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 20, 2017, 6:59pm UTC](https://discuss.elastic.co/t/scripted-date-field-returns-invalid-date/82980/7 "2017-05-20T18:59:55Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.