# Data Visualizer won't accept dd/mm/yyyy format when importing data
**URL:** https://discuss.elastic.co/t/data-visualizer-wont-accept-dd-mm-yyyy-format-when-importing-data/285732
**Category:** Kibana
**Tags:** elastic-stack-machine-learning
**Created:** [October 2, 2021, 10:12am UTC](https://discuss.elastic.co/t/data-visualizer-wont-accept-dd-mm-yyyy-format-when-importing-data/285732 "2021-10-02T10:12:40Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Stud21](https://discuss.elastic.co/u/Stud21)
#### Post date: [October 2, 2021, 10:12am UTC](https://discuss.elastic.co/t/data-visualizer-wont-accept-dd-mm-yyyy-format-when-importing-data/285732/1 "2021-10-02T10:12:40Z")
I'm trying to import the films.csv file in Data Visualizer and it gives me a 'date\_time\_exception' error.
Trying to import the data by 'Apply override settings' link it just does not accept the format, 'dd/mm/yyyy''
How do I import the date.
I'm using KIbana version v 7.10.1
---
### Author:  [@droberts195](https://discuss.elastic.co/u/droberts195)
#### Post date: [October 2, 2021, 11:18am UTC](https://discuss.elastic.co/t/data-visualizer-wont-accept-dd-mm-yyyy-format-when-importing-data/285732/2 "2021-10-02T11:18:03Z")
`mm` is for minutes. You probably want `MM` for months.
---
### Author:  [@Stud21](https://discuss.elastic.co/u/Stud21)
#### Post date: [October 3, 2021, 9:55pm UTC](https://discuss.elastic.co/t/data-visualizer-wont-accept-dd-mm-yyyy-format-when-importing-data/285732/3 "2021-10-03T21:55:04Z")
Yes,
I did try MM and even MMM; no luck
---
### Author:  [@richcollier](https://discuss.elastic.co/u/richcollier)
#### Post date: [October 4, 2021, 12:12pm UTC](https://discuss.elastic.co/t/data-visualizer-wont-accept-dd-mm-yyyy-format-when-importing-data/285732/4 "2021-10-04T12:12:51Z")
can you provide the first few lines of `films.csv` for reference so we can see?
---
### Author:  [@Stud21](https://discuss.elastic.co/u/Stud21)
#### Post date: [October 5, 2021, 10:49pm UTC](https://discuss.elastic.co/t/data-visualizer-wont-accept-dd-mm-yyyy-format-when-importing-data/285732/5 "2021-10-05T22:49:08Z")
Please find as below:
name,directed\_by,genre,id,initial\_release\_date
0.45,Gary Lennon,Black comedy|Thriller|Psychological thriller|Indie film|Action Film|Crime Thriller|Crime Fiction|Drama,/en/45\_2006,30/11/2006
9,Shane Acker,Computer Animation|Animation|Apocalyptic and post-apocalyptic fiction|Science Fiction|Short Film|Thriller|Fantasy,/en/9\_2005,21/04/2005
---
### Author:  [@droberts195](https://discuss.elastic.co/u/droberts195)
#### Post date: [October 6, 2021, 9:22am UTC](https://discuss.elastic.co/t/data-visualizer-wont-accept-dd-mm-yyyy-format-when-importing-data/285732/6 "2021-10-06T09:22:58Z")
I just tried your file using the latest master branch code and it worked fine:
The date format was automatically detected as `dd/MM/yyyy`. The overrides page shows it, but I didn't have to type this in as it was automatically detected:
Can you provide some screenshots of the problems you're seeing? Maybe it's nothing to do with the date format but something else?
Also, you didn't say which version you were using. Really old versions of the file data visualizer had some bugs that you could be hitting. (But really really old versions of the data visualizer didn't support custom date format overrides at all, so I guess you're not using one of those.)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 3, 2021, 9:23am UTC](https://discuss.elastic.co/t/data-visualizer-wont-accept-dd-mm-yyyy-format-when-importing-data/285732/7 "2021-11-03T09:23:10Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.