# Kanban, group by date AND sort by date **URL:** \ **Category:** Ask for Help\ **Created:** [April 18, 2023, 5:55am UTC](https://community.glideapps.com/t/kanban-group-by-date-and-sort-by-date/60670 "2023-04-18T05:55:52Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Jonne\_Paes](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonne_paes/32/1162_2.png) [@Jonne\_Paes](https://community.glideapps.com/u/Jonne_Paes)\ **Post date:** [April 18, 2023, 5:55am UTC](https://community.glideapps.com/t/kanban-group-by-date-and-sort-by-date/60670/1 "2023-04-18T05:55:52Z")
Hi, I want to use a Kanban view to group items by date. My items have a date-column and I can group the Kanban view by it. But the only problem is that it does not sort in the correct order. So the first column is 18 April, second 30 April and the third 21 April. Anyone a solution to solve this? Thanks in advance! ---
**Author:** ![JoeSuarez](https://avatars.discourse-cdn.com/v4/letter/j/958977/32.png) [@JoeSuarez](https://community.glideapps.com/u/JoeSuarez)\ **Post date:** [April 18, 2023, 6:41am UTC](https://community.glideapps.com/t/kanban-group-by-date-and-sort-by-date/60670/2 "2023-04-18T06:41:19Z")
> [@Jonne\_Paes](#): > > I want to use a Kanban view to group items by date. My items have a date-column and I can group the Kanban view by it. But the only problem is that it does not sort in the correct order. So the first column is 18 April, second 30 April and the third 21 April. Anyone a solution to solve this? > > Thanks in advance! One solution to sort items in a Kanban view by date is to convert the date-column values into a format that can be sorted lexicographically. One common format that works well for this purpose is the ISO 8601 date format, which has the format `YYYY-MM-DD`. You can follow these steps: 1. Ensure that your date-column contains dates in a consistent format. If not, you may need to reformat the date values in your date-column to a standard date format such as `YYYY-MM-DD`. 2. Create a new column in your Kanban view, let’s call it “Sort Date”, and set its values to be the formatted dates from the date-column. You can use a formula to convert the date values into the ISO 8601 format. For example, if your date-column is named “Date”, you can use a formula like this in the “Sort Date” column: =FORMAT\_DATE(‘YYYY-MM-DD’, {Date}) By following these steps, you should be able to use the Kanban view to group items by date and have them sorted correctly based on the “Sort Date” column in the ISO 8601 date format. ---
**Author:** ![Jonne\_Paes](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonne_paes/32/1162_2.png) [@Jonne\_Paes](https://community.glideapps.com/u/Jonne_Paes)\ **Post date:** [April 18, 2023, 7:04am UTC](https://community.glideapps.com/t/kanban-group-by-date-and-sort-by-date/60670/3 "2023-04-18T07:04:48Z")
@JoeSuarez I use Glide Tables so thought it was possible to use the ‘format date’ standard formula provided by Glide. When I use ‘YYYY-MM-DD’, this happens: ![Scherm­afbeelding 2023-04-18 om 09.01.04](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bb3e67b7806c95fc3b1932ffde7ade95e91c760d.jpeg) I also tried ‘yyyy-MM-dd’ which gives a correct date, but it does not sort correctly in the Kanban view. Do you know what I’m doing wrong? ![Scherm­afbeelding 2023-04-18 om 09.04.00](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d3575dd38edd9d8bf1553e609589c34f931ef6da.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 19, 2023, 12:45am UTC](https://community.glideapps.com/t/kanban-group-by-date-and-sort-by-date/60670/4 "2023-04-19T00:45:49Z")
Can you show us the configuration of your Kanban component? How many days you want to show as “groupings”? ---
**Author:** ![Jonne\_Paes](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonne_paes/32/1162_2.png) [@Jonne\_Paes](https://community.glideapps.com/u/Jonne_Paes)\ **Post date:** [April 19, 2023, 9:06am UTC](https://community.glideapps.com/t/kanban-group-by-date-and-sort-by-date/60670/5 "2023-04-19T09:06:46Z")
@ThinhDinh, I would like at least 5-7 days as ‘groupings’. Here is the configuration: ![Scherm­afbeelding 2023-04-19 om 11.05.19](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/3/a393fbb19d8de06005e9ebc59e80bb8295cc6f41.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 20, 2023, 12:17am UTC](https://community.glideapps.com/t/kanban-group-by-date-and-sort-by-date/60670/6 "2023-04-20T00:17:57Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/9/5924693452fe780000cc04b3946e6980c0d1fe8c.png) I don’t think it’s very intuitive, but maybe you can have multiple columns as “Today”, “Day - 1”, “Day - 2” etc, then use them in custom groups.