# Convert Date String Into Date Format

**URL:** <https://discuss.elastic.co/t/convert-date-string-into-date-format/193913>\
**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:** 12\
**Page:** 6

<div class="post-metadata">

**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 17, 2019, 6:37am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/102 "2019-08-17T06:37:16Z")

</div>

🙂

---

<div class="post-metadata">

**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 18, 2019, 1:39pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/103 "2019-08-18T13:39:14Z")

</div>

sorry to disturb @admlko but when i try 4/30/2019 1:35:16  
M/dd/yyyy H:mm:ss it does not convert

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/f/efca91136730eff5a1c543bf2040cc3e77fe9d08.png)

---

<div class="post-metadata">

**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 18, 2019, 1:42pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/104 "2019-08-18T13:42:37Z")

</div>

My config file  
input {  
file {  
path =\> "D:/kibanaproject/kesample.csv"  
start\_position =\> "beginning"  
sincedb\_path =\> "NUL"  
}  
}  
filter {

if ([message] =~ "\bDate\b") {  
drop { }  
} else {

```
csv { 
	separator => "," 
	columns => ["Date","mobile","Telco","SCode","SMSLength","msg","Category"] 
}

date {

```

match =\> ["Date", "M/dd/yyyy H:mm:ss"]  
target =\> "Date"  
}  
}   
}  
output {  
elasticsearch {  
hosts =\> ["localhost:9200"]  
index =\> "evening%{+dd.MM.YYYY}"  
}  
stdout {codec =\> json\_lines }  
}

---

<div class="post-metadata">

**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 18, 2019, 1:44pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/105 "2019-08-18T13:44:46Z")

</div>

Date,mobile,Telco,SCode,SMSLength,msg,Category  
4/30/2019 1:35:16 ,923442122939,Telenor,8119,1,"Dear Customer, due to maintenance shutdown, the supply to your area (A/C #400005067403) may be affected on 30 Apr between 1PM-5PM. Inconvenience regretted.KE",Maintenance Shutdown

This is the sample record in which i test the config file

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [August 18, 2019, 2:30pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/106 "2019-08-18T14:30:06Z")

</div>

You have a space at the end of the [Date] field, so you need a trailing space in your date filter.

---

<div class="post-metadata">

**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 18, 2019, 6:09pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/107 "2019-08-18T18:09:45Z")

</div>

input {  
file {  
path =\> "D:/kibanaproject/kesample.csv"  
start\_position =\> "beginning"  
sincedb\_path =\> "NUL"  
}  
}  
filter {  
if ([message] =~ "\bDate\b") {  
drop { }  
} else {  
csv {  
separator =\> ","  
columns =\> ["Date","mobile","Telco","SCode","SMSLength","msg","Category"]  
}  
date {  
match =\> ["Date","M/dd/yyyy H:mm:ss"]  
target =\> "Date"  
}  
}   
}  
output {  
elasticsearch {  
hosts =\> ["localhost:9200"]  
index =\> "night%{+dd.MM.YYYY}"  
}  
stdout {codec =\> json\_lines }  
}

---

<div class="post-metadata">

**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 18, 2019, 6:10pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/108 "2019-08-18T18:10:07Z")

</div>

i have remove spaces still result is the same

---

<div class="post-metadata">

**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 18, 2019, 6:10pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/109 "2019-08-18T18:10:26Z")

</div>

Date,mobile,Telco,SCode,SMSLength,msg,Category  
4/30/2019 1:35:16 PM,923442122939,Telenor,8119,1,"Dear Customer, due to maintenance shutdown, the supply to your area (A/C #400005067403) may be affected on 30 Apr between 1PM-5PM. Inconvenience regretted.KE",Maintenance Shutdown

---

<div class="post-metadata">

**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 18, 2019, 6:10pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/110 "2019-08-18T18:10:46Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/9/d/9d89d0449e1390c29686fea7fecaf38d81740e5a.png)

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [August 18, 2019, 6:58pm UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/111 "2019-08-18T18:58:59Z")

</div>

> [@Syed.Ubaid](#):
>
> 4/30/2019 1:35:16 PM

You would need to add "a" to the pattern to match the AM/PM.

---

<div class="post-metadata">

**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 19, 2019, 4:02am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/112 "2019-08-19T04:02:51Z")

</div>

Thanks a ton issue is resolved !!

---

<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:** [September 16, 2019, 4:02am UTC](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913/113 "2019-09-16T04:02:53Z")

</div>

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

[Previous page](https://discuss.elastic.co/t/convert-date-string-into-date-format/193913.md?page=5)