# Kibana Ingest pipeline Convert String to Date?

**URL:** <https://discuss.elastic.co/t/kibana-ingest-pipeline-convert-string-to-date/313836>\
**Category:** Kibana\
**Tags:** ingest-pipeline\
**Created:** [September 7, 2022, 12:57am UTC](https://discuss.elastic.co/t/kibana-ingest-pipeline-convert-string-to-date/313836 "2022-09-07T00:57:25Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![eagles40cnuh](https://avatars.discourse-cdn.com/v4/letter/e/edb3f5/32.png) [@eagles40cnuh](https://discuss.elastic.co/u/eagles40cnuh)\
**Post date:** [September 7, 2022, 12:57am UTC](https://discuss.elastic.co/t/kibana-ingest-pipeline-convert-string-to-date/313836/1 "2022-09-07T00:57:25Z")

</div>

1. Installed elastic-agent on the server and Collect Custom Log Data

2. I was Create a pipeline in Kibana (Stack Management -\> Ingest pipelines)

3. And "Message" Field -\> Split Data (Success)

How can I Convert String Field to Date Type in "Manage processor"?

- "Time" Field is String

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

---

<div class="post-metadata">

**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\
**Post date:** [September 7, 2022, 4:33pm UTC](https://discuss.elastic.co/t/kibana-ingest-pipeline-convert-string-to-date/313836/2 "2022-09-07T16:33:30Z")

</div>

Check the **Date Processor**

> **[Date processor | Elasticsearch Guide \[8.4\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/date-processor.html)**

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

---

<div class="post-metadata">

**Author:** ![eagles40cnuh](https://avatars.discourse-cdn.com/v4/letter/e/edb3f5/32.png) [@eagles40cnuh](https://discuss.elastic.co/u/eagles40cnuh)\
**Post date:** [September 8, 2022, 12:10am UTC](https://discuss.elastic.co/t/kibana-ingest-pipeline-convert-string-to-date/313836/3 "2022-09-08T00:10:45Z")

</div>

I set it like this

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/5/c54244040c519f4f0602eeca816684c560bba0f1.png)

But.... I get this Error

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/5/850ca4b95c4cee424994c7b2a27be32059921d97.png)

---

<div class="post-metadata">

**Author:** ![leandrojmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leandrojmp/32/107231_2.png) [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)\
**Post date:** [September 8, 2022, 1:28am UTC](https://discuss.elastic.co/t/kibana-ingest-pipeline-convert-string-to-date/313836/4 "2022-09-08T01:28:14Z")

</div>

Probably because the string `2022-09-08 00:09:12.141` does not match the `ISO8601` date format.

Try to use this in the format `yyyy-MM-dd HH:mm:ss.SSS`

---

<div class="post-metadata">

**Author:** ![eagles40cnuh](https://avatars.discourse-cdn.com/v4/letter/e/edb3f5/32.png) [@eagles40cnuh](https://discuss.elastic.co/u/eagles40cnuh)\
**Post date:** [September 8, 2022, 1:48am UTC](https://discuss.elastic.co/t/kibana-ingest-pipeline-convert-string-to-date/313836/5 "2022-09-08T01:48:15Z")

</div>

After changing the settings "ISO8601 -\> yyyy-MM-dd HH:mm:ss.SSS" (Success!!!)

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

But column type Looks like String....

How can I Convert this type? (String -\> Date)

---

<div class="post-metadata">

**Author:** ![leandrojmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leandrojmp/32/107231_2.png) [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)\
**Post date:** [September 8, 2022, 2:19am UTC](https://discuss.elastic.co/t/kibana-ingest-pipeline-convert-string-to-date/313836/6 "2022-09-08T02:19:44Z")

</div>

> [@eagles40cnuh](#):
>
> But column type Looks like String....
> 
> How can I Convert this type? (String -\> Date)

It is the mapping in elasticsearch, only way to change it is creating a new index.

---

<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:** [October 6, 2022, 2:19am UTC](https://discuss.elastic.co/t/kibana-ingest-pipeline-convert-string-to-date/313836/7 "2022-10-06T02:19:47Z")

</div>

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