# Convert Date String Into Date Format **URL:** \ **Category:** Logstash\ **Created:** [August 6, 2019, 4:10am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913 "2019-08-06T04:10:30Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 6, 2019, 12:48pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/21 "2019-08-06T12:48:58Z")
I have added the date format as u told me then run the config file it still showing the same date type string please check the attached screenshot `![Date%20String|690x407](upload://bWcwOu6aLJfyhRZjtVrkK1rOOOz.jpeg)` ---
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 6, 2019, 12:50pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/22 "2019-08-06T12:50:39Z")
![Date%20String](https://us1.discourse-cdn.com/elastic/original/3X/5/3/53ac2eb5949018cd8971040a5e0a3602a737e387.jpeg) ---
**Author:** ![dgonzalezp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dgonzalezp/32/50804_2.png) [@dgonzalezp](https://discuss.elastic.co/u/dgonzalezp)\ **Post date:** [August 6, 2019, 1:06pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/23 "2019-08-06T13:06:53Z")
Im sorry @Syed.Ubaid I have no idea by now, but I will keep trying to fix your problem. ---
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 6, 2019, 1:14pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/24 "2019-08-06T13:14:04Z")
Thank you ---
**Author:** ![jmilot](https://avatars.discourse-cdn.com/v4/letter/j/77aa72/32.png) [@jmilot](https://discuss.elastic.co/u/jmilot)\ **Post date:** [August 6, 2019, 1:30pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/25 "2019-08-06T13:30:01Z")
Hi, What have you in your template index for this field ? Date : { "type": "date", "format": "MM/DD/YYYY HH:mm" } ---
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 7, 2019, 5:28am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/27 "2019-08-07T05:28:40Z")
How can we use template index and can we do this through mapping? any screenshot or links ? ---
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 7, 2019, 6:08am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/28 "2019-08-07T06:08:55Z")
![Date%20String](https://us1.discourse-cdn.com/elastic/original/3X/b/7/b765a49273d8e3ea09f87bbc00a10b7b3ddeac9c.jpeg) please check the attached picture in the mapping data type of date is showing text how can we change the current mapping to change type text to date ---
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 7, 2019, 6:32am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/29 "2019-08-07T06:32:00Z")
![Date%20String](https://us1.discourse-cdn.com/elastic/original/3X/5/2/52f78d85cf878d2ad43710b5dbb4936214ad3027.png) Please see the attached file, the error occured when update date field from existing index. please look into it. ---
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 7, 2019, 12:12pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/30 "2019-08-07T12:12:14Z")
any update @dgonzalezp dgonzalezp ---
**Author:** ![dgonzalezp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dgonzalezp/32/50804_2.png) [@dgonzalezp](https://discuss.elastic.co/u/dgonzalezp)\ **Post date:** [August 8, 2019, 6:06am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/31 "2019-08-08T06:06:18Z")
Hi @Syed.Ubaid Sorry, yesterday I was a little bit busy and I couldnt help you. I can change my fields in date format to srtring in this section: ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/9/09c7907d9b43bd6b2ec30afd375f24938fd20d5b.png) Can you did it from string to date? ---
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 8, 2019, 6:09am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/32 "2019-08-08T06:09:30Z")
I have string value field you have date value field please check the attached screenshot ![Date%20String](https://us1.discourse-cdn.com/elastic/original/3X/6/a/6a4fcb2d4d664ecf65874611996832ece3e7e822.png) ---
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 8, 2019, 6:10am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/33 "2019-08-08T06:10:34Z")
timestamp is by default in date format the problem is that i want to convert the date string into date format so i would do aggregation on date column ---
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 8, 2019, 6:12am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/34 "2019-08-08T06:12:33Z")
now see this screenshot timestamp is coming in date format ![Date%20String](https://us1.discourse-cdn.com/elastic/original/3X/8/d/8d9d065c90cd001c32127320371e915b9978ed9c.png) i want the date column type into date format which is by default is coming into string format.. ---
**Author:** ![dgonzalezp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dgonzalezp/32/50804_2.png) [@dgonzalezp](https://discuss.elastic.co/u/dgonzalezp)\ **Post date:** [August 8, 2019, 7:13am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/35 "2019-08-08T07:13:27Z")
What kind of input/filter/output have you in your logstash? Can you share all these files? I want to see them, maybe the problem is in there. ---
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 8, 2019, 7:24am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/36 "2019-08-08T07:24:56Z")
input { file { path =\> "D:/kibanaproject/testing.csv" start\_position =\> "beginning" sincedb\_path =\> "NUL" } } filter { csv { separator =\> "," columns =\> ["Date","MobileNo","Msg","ServiceId","SMS","wsResponse","AKNMsgId","MMMsgId","AmountCharged"] } } output { elasticsearch { hosts =\> ["localhost:9200"] index =\> "test-%{+dd.MM.YYYY}" } stdout {codec =\> json\_lines } } ---
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 8, 2019, 7:25am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/37 "2019-08-08T07:25:42Z")
this is my config file ---
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 8, 2019, 7:26am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/38 "2019-08-08T07:26:36Z")
mutate { convert =\> { "Date" =\> "date" } } } when i put this filter it does not parse the data. ---
**Author:** ![dgonzalezp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dgonzalezp/32/50804_2.png) [@dgonzalezp](https://discuss.elastic.co/u/dgonzalezp)\ **Post date:** [August 8, 2019, 8:09am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/39 "2019-08-08T08:09:16Z")
Try this: > filter { > csv { > separator =\> "," > columns =\> ["Date","MobileNo","Msg","ServiceId","SMS","wsResponse","AKNMsgId","MMMsgId","AmountCharged"] > convert =\> { "Date" =\> "date" } > } > } ---
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 8, 2019, 8:46am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/40 "2019-08-08T08:46:34Z")
i tried this but error in logstash service start and stop ---
**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\ **Post date:** [August 8, 2019, 8:50am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/41 "2019-08-08T08:50:52Z")
it works logstash parse the data but date format still showing in string [Previous page](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913.md?page=1) [Next page](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913.md?page=3)