# Date visualization error
**URL:** https://discuss.elastic.co/t/date-visualization-error/213098
**Category:** Kibana
**Created:** [December 26, 2019, 4:18pm UTC](https://discuss.elastic.co/t/date-visualization-error/213098 "2019-12-26T16:18:15Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@ronics](https://discuss.elastic.co/u/ronics)
#### Post date: [December 26, 2019, 4:18pm UTC](https://discuss.elastic.co/t/date-visualization-error/213098/1 "2019-12-26T16:18:15Z")
I have multiple date field in RDMS data. I have downloaded it in csv format for every month. I have converted string field into date using mutate. When I try it create visualization in kibana, the date field only shows the data of jan 2019.
I have data from jan 1 2019 to dec 25 2019 in csv in multiple files.
Total records is 24 lakhs
In kibana, all datas (24 lakhs) are shown in jan month only.
string is 12-Dec-19
date {
match =\> ["ENTER\_DATE", "DD-MMM-YY"]
target =\> "ENTER\_DATE"
}
date
{
match =\> ["UPDATE\_TIME", "DD-MMM-YY"]
target =\> "UPDATE\_TIME"
}
date
{
match =\> ["SEND\_DATE", "DD-MMM-YY"]
target =\> "SEND\_DATE"
}
String is converted to date in kibana successfully but the data of dec month is override with jan month.
---
### Author:  [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)
#### Post date: [December 26, 2019, 5:05pm UTC](https://discuss.elastic.co/t/date-visualization-error/213098/2 "2019-12-26T17:05:03Z")
Hello,
I am a bit confused. What does your date fields show in Discover? Are they showing values for all the months you expect?
Also what is the mapping of this field in Elasticsearch? Can you query the values directly and ES and check if they have correct values for month?
Thanks,
Bhavya
---
### Author:  [@ronics](https://discuss.elastic.co/u/ronics)
#### Post date: [December 27, 2019, 9:14am UTC](https://discuss.elastic.co/t/date-visualization-error/213098/3 "2019-12-27T09:14:38Z")
There was problem while creating index. It is solved it. Thanks.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 24, 2020, 9:14am UTC](https://discuss.elastic.co/t/date-visualization-error/213098/4 "2020-01-24T09:14:38Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.