# How to Sort Date in Kibana Visualization
**URL:** https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221
**Category:** Kibana
**Created:** [November 25, 2019, 5:57am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221 "2019-11-25T05:57:26Z")
**Posts on this page:** 14
**Page:** 1
### Author:  [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)
#### Post date: [November 25, 2019, 5:57am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221/1 "2019-11-25T05:57:26Z")
Hi i am using kibana interface for visualization while i have a column date which contain 2 month dates but when i sort date ascending it does not sort the date in order wise. Can someone help me how to sort the date in kibana
---
### Author:  [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)
#### Post date: [November 25, 2019, 6:04am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221/2 "2019-11-25T06:04:02Z")
 now if you see the images the dates are not sorted first column show date 8/31/2019 then 10 then 9 please help
---
### Author:  [@Zany](https://discuss.elastic.co/u/Zany)
#### Post date: [November 25, 2019, 6:48am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221/3 "2019-11-25T06:48:10Z")
Hi Syed, you need to click the column header to sort it. From your image, it is showing that the column is not sorted in any order.
The arrow in the column should be pointing up to show that it is sorted in ascending order.
---
### Author:  [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)
#### Post date: [November 25, 2019, 7:02am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221/4 "2019-11-25T07:02:59Z")
Zany if you look at the image
 I have selected column date and it sorts ascending
---
### Author:  [@Zany](https://discuss.elastic.co/u/Zany)
#### Post date: [November 25, 2019, 7:06am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221/5 "2019-11-25T07:06:44Z")
Based on what I see, you have selected `Metric: Count` as your **default** sorting criteria in your configuration for this visualization. You should select your Date column instead.
---
### Author:  [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)
#### Post date: [November 25, 2019, 7:09am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221/6 "2019-11-25T07:09:04Z")
Date datatype by default is showing string... For datatype change string to date i have to convert the date datatype into Date???
---
### Author:  [@Zany](https://discuss.elastic.co/u/Zany)
#### Post date: [November 25, 2019, 7:09am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221/7 "2019-11-25T07:09:52Z")
Yes, you should change to date type, otherwise it is going to sort alphanumerically. The best practice is to format your fields into the most fitting data type.
---
### Author:  [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)
#### Post date: [November 25, 2019, 7:11am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221/8 "2019-11-25T07:11:34Z")
ok thank you my date format is 8/31/2019 so i have to put mm/dd/YYYY to convert ?
---
### Author:  [@Zany](https://discuss.elastic.co/u/Zany)
#### Post date: [November 25, 2019, 7:17am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221/9 "2019-11-25T07:17:50Z")
There are input format and output format. Assuming you are not going to change the format, you should use `MM/D/YYYY`. You can try it out in the preview box in the Index Pattern field setting.
---
### Author:  [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)
#### Post date: [November 25, 2019, 7:20am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221/10 "2019-11-25T07:20:32Z")
Thank you
---
### Author:  [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)
#### Post date: [November 25, 2019, 7:53am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221/11 "2019-11-25T07:53:43Z")
i have tried to convert date filed but it gives error
my date format is 8/31/2019
and i use date {
match =\> ["Date", "MM/dd/yyyy"]
target =\> "Date"
}
---
### Author:  [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)
#### Post date: [November 25, 2019, 10:08am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221/12 "2019-11-25T10:08:56Z")
Issue has been resolved data format has been converted....
---
### Author:  [@Zany](https://discuss.elastic.co/u/Zany)
#### Post date: [December 3, 2019, 5:28am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221/13 "2019-12-03T05:28:51Z")
Please mark my reply as the correct answer if it helped. Thanks!
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 31, 2019, 5:28am UTC](https://discuss.elastic.co/t/how-to-sort-date-in-kibana-visualization/209221/14 "2019-12-31T05:28:58Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.