# Kibana two csv date

**URL:** https://discuss.elastic.co/t/kibana-two-csv-date/172674
**Category:** Kibana
**Created:** [March 17, 2019, 11:55am UTC](https://discuss.elastic.co/t/kibana-two-csv-date/172674 "2019-03-17T11:55:46Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![andrew\_xoa](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrew_xoa/32/42185_2.png) [@andrew\_xoa](https://discuss.elastic.co/u/andrew_xoa)
#### Post date: [March 17, 2019, 11:55am UTC](https://discuss.elastic.co/t/kibana-two-csv-date/172674/1 "2019-03-17T11:55:46Z")

</div>

Hi, I have two csv files containing both date field.  
the first file csv data field contains numerous dates belonging to the same day, the second file csv contains in the date field a single day having further information on its line.  
Here I would like to combine the two dates to return the filtered information for a single date also in the second csv file that has additional information.  
I imported the csv files into machine learning and imported the files by changing the date format in both csv files from the advanced settings.  
con:

```
"Data": { 
"type": "date",
"format": "DD/MM/YYYY"
    },

```

but I can't filter them as a single date !

Thanks!

---

<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: [March 17, 2019, 11:44pm UTC](https://discuss.elastic.co/t/kibana-two-csv-date/172674/2 "2019-03-17T23:44:12Z")

</div>

See: [Data Visualizer - CSV Import - Date Mapping issue with Empty Sting/NULL values](https://discuss.elastic.co/t/data-visualizer-csv-import-date-mapping-issue-with-empty-sting-null-values/160242/4?u=richcollier)

The CSV upload feature of ML doesn't support that date format.

---

<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: [April 14, 2019, 11:44pm UTC](https://discuss.elastic.co/t/kibana-two-csv-date/172674/3 "2019-04-14T23:44:20Z")

</div>

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