# Kibana won't recognise a field as a date

**URL:** <https://discuss.elastic.co/t/kibana-wont-recognise-a-field-as-a-date/187868>\
**Category:** Kibana\
**Created:** [June 27, 2019, 2:18pm UTC](https://discuss.elastic.co/t/kibana-wont-recognise-a-field-as-a-date/187868 "2019-06-27T14:18:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pdimitri](https://avatars.discourse-cdn.com/v4/letter/p/b5a626/32.png) [@pdimitri](https://discuss.elastic.co/u/pdimitri)\
**Post date:** [June 27, 2019, 2:18pm UTC](https://discuss.elastic.co/t/kibana-wont-recognise-a-field-as-a-date/187868/1 "2019-06-27T14:18:52Z")

</div>

Hi.

I have a CSV file with a field called `posted_at` which takes date and time values, formatted like this: 01/01/2019 12:34:56.

I have been uploading this CSV to Kibana with the intention of creating visualisations, including a date histogram, but `posted_at` is always given the "keyword" type, rather than the "date" type.

I have tried:

- Overriding the settings in the summary page before importing.
- Editing the mappings to give `posted_at` the "date" type before importing.
- Changing the date format under advanced settings after importing.
- Formatting the date differently in the original CSV and re-importing.
- Reading through previous similar threads and trying those solutions.

Nothing has worked - `posted_at` is given the "keyword" type no matter what I try.

How can I rectify this? Is there a specific format I need to have in the CSV for the field to be recognised as a date?

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![pdimitri](https://avatars.discourse-cdn.com/v4/letter/p/b5a626/32.png) [@pdimitri](https://discuss.elastic.co/u/pdimitri)\
**Post date:** [July 3, 2019, 8:37am UTC](https://discuss.elastic.co/t/kibana-wont-recognise-a-field-as-a-date/187868/2 "2019-07-03T08:37:24Z")

</div>

SOLVED!

To anyone with the same problem in the future - change the date format in your CSV to `2019-01-01 00:00:00`.

I did this and then Kibana immediately recognised the field as a date.

---

<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:** [July 31, 2019, 8:07pm UTC](https://discuss.elastic.co/t/kibana-wont-recognise-a-field-as-a-date/187868/4 "2019-07-31T20:07:24Z")

</div>

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