# Data Visualizer - CSV Import - Date Mapping issue with Empty Sting/NULL values

**URL:** <https://discuss.elastic.co/t/data-visualizer-csv-import-date-mapping-issue-with-empty-sting-null-values/160242>\
**Category:** Kibana\
**Tags:** elastic-stack-machine-learning\
**Created:** [December 10, 2018, 8:46pm UTC](https://discuss.elastic.co/t/data-visualizer-csv-import-date-mapping-issue-with-empty-sting-null-values/160242 "2018-12-10T20:46:36Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![richcollier](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/richcollier/32/115035_2.png) [@richcollier](https://discuss.elastic.co/u/richcollier)\
**Post date:** [December 12, 2018, 1:01pm UTC](https://discuss.elastic.co/t/data-visualizer-csv-import-date-mapping-issue-with-empty-sting-null-values/160242/4 "2018-12-12T13:01:02Z")

</div>

The CSV import functionality is indeed new (and experimental in v6.5). You can see [from the docs](https://www.elastic.co/guide/en/elasticsearch/reference/6.5/ml-find-file-structure.html) that the following date formats are supported:

```auto
dd/MMM/YYYY:HH:mm:ss Z
EEE MMM dd HH:mm zzz YYYY
EEE MMM dd HH:mm:ss YYYY
EEE MMM dd HH:mm:ss zzz YYYY
EEE MMM dd YYYY HH:mm zzz
EEE MMM dd YYYY HH:mm:ss zzz
EEE, dd MMM YYYY HH:mm Z
EEE, dd MMM YYYY HH:mm ZZ
EEE, dd MMM YYYY HH:mm:ss Z
EEE, dd MMM YYYY HH:mm:ss ZZ
ISO8601
MMM d HH:mm:ss
MMM d HH:mm:ss,SSS
MMM d YYYY HH:mm:ss
MMM dd HH:mm:ss
MMM dd HH:mm:ss,SSS
MMM dd YYYY HH:mm:ss
MMM dd, YYYY h:mm:ss a
TAI64N
UNIX
UNIX_MS
YYYY-MM-dd HH:mm:ss
YYYY-MM-dd HH:mm:ss,SSS
YYYY-MM-dd HH:mm:ss,SSS Z
YYYY-MM-dd HH:mm:ss,SSSZ
YYYY-MM-dd HH:mm:ss,SSSZZ
YYYY-MM-dd HH:mm:ssZ
YYYY-MM-dd HH:mm:ssZZ
YYYYMMddHHmmss

```

Your date format isn't one of those.

---

_[View the full topic](https://discuss.elastic.co/t/data-visualizer-csv-import-date-mapping-issue-with-empty-sting-null-values/160242)._