# \[DONE\] Choose order of empty values when sorting on Date field **URL:** \ **Category:** Ideas & Features\ **Tags:** views\ **Created:** [September 30, 2020, 12:41pm UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019 "2020-09-30T12:41:39Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![XLN](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/xln/32/948_2.png) [@XLN](https://community.fibery.io/u/XLN)\ **Post date:** [September 30, 2020, 12:41pm UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/1 "2020-09-30T12:41:39Z")
Hi, When we create a board view which is sorted on a Date field, if some cards have no date value filled in, then they are always displayed before cards which contain date values. This is problematic because when we want to display a classic “to do” list with cards sorted on “ascending” dates (to see on top what to do next), then all the cards without dates are coming first. It would be great if we could choose if cards containing an empty field are displayed before of after. Maybe with 4 choices instead of 2 : - ascending then empty - descending then empty - empty then ascending - empty the descending Xavier ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [September 30, 2020, 1:22pm UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/2 "2020-09-30T13:22:49Z")
You could probably achieve this with a workaround using a formula field, e.g. SortDate = if(IsEmpty(Date),Date(1,1,1900),Date) or SortDate = if(IsEmpty(Date),Date(1,1,2100),Date) Then you can sort your board (ascending or descending) on the formula field instead of the original date field. You can still have the cards showing the Date field though 🙂 (I’m assuming none of your entities have dates before 1st Jan 1900 or after 1st Jan 2100!) ---
**Author:** ![XLN](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/xln/32/948_2.png) [@XLN](https://community.fibery.io/u/XLN)\ **Post date:** [September 30, 2020, 5:58pm UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/3 "2020-09-30T17:58:36Z")
Thank you for your help. That would work indeed, but then we would not see easily anymore which cards actually have a date set or not (and we need to see that), except by using colors but we already use it for something else… Anyway that trick may be handy for some other boards so I keep it in mind ! ---
**Author:** ![Oshyan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/oshyan/32/11431_2.png) [@Oshyan](https://community.fibery.io/u/Oshyan)\ **Post date:** [September 30, 2020, 6:11pm UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/4 "2020-09-30T18:11:27Z")
+1 from me. I found this annoying too, but didn’t think to make a feature request from it. 😃 ---
**Author:** ![B\_Sp](https://avatars.discourse-cdn.com/v4/letter/b/e8c25b/32.png) [@B\_Sp](https://community.fibery.io/u/B_Sp)\ **Post date:** [October 17, 2020, 3:06am UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/5 "2020-10-17T03:06:31Z")
As always Chris impressed by your capabilities with formulas, but this is just too much work and shouldn’t be necessary if a good solution was in place. Second @Oshyan with a +1 of simply some work by the team to resolve this natively within Fibery. Thanks! ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [October 30, 2020, 7:23pm UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/6 "2020-10-30T19:23:42Z")
We’ve fixed that, should be released in the next build. Empty values will be visible if sorting is applied ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [November 5, 2020, 11:12am UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/7 "2020-11-05T11:12:07Z")
This bug is fixed, empty values remain visible when sorting is applied ---
**Author:** ![XLN](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/xln/32/948_2.png) [@XLN](https://community.fibery.io/u/XLN)\ **Post date:** [November 5, 2020, 1:09pm UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/8 "2020-11-05T13:09:56Z")
Hi, thanks for the bug fix, however in this thread we would like to achieve a more fine-grained sorting, for instance being able to sort by “ascending then empty values”. Right now if we put an “ascending” filter on a date filed, and there are some cards with a date value, and some othercards without (“backlog” cards) : the cards without date value are always listed first, whereas we would like to have them displayed at the end, while still having an ascending order for the cards at the beginning that have a date value. ---
**Author:** ![Polina\_Zenevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/polina_zenevich/32/480_2.png) [@Polina\_Zenevich](https://community.fibery.io/u/Polina_Zenevich)\ **Post date:** [November 5, 2020, 2:00pm UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/9 "2020-11-05T14:00:06Z")
Well, our UI sorting logic was like that - if asc then null at the beginning. If desc, then null at the end. It is pretty complicated to find a solution, that will work for everyone. Thanks for the feedback anyway, it is noted and we will discuss that. I Will let you know if there will be any update. ---
**Author:** ![Louis-FelixBorealys](https://avatars.discourse-cdn.com/v4/letter/l/58956e/32.png) [@Louis-FelixBorealys](https://community.fibery.io/u/Louis-FelixBorealys)\ **Post date:** [November 28, 2021, 10:56pm UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/10 "2021-11-28T22:56:52Z")
+1 for this! Maybe just add to the sorting options (ascending and descending) “ascending then empty dates, empty dates then ascending, descending then empty date, empty dates then descending” ? 😁 ---
**Author:** ![Lee\_Denny](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/lee_denny/32/8158_2.png) [@Lee\_Denny](https://community.fibery.io/u/Lee_Denny)\ **Post date:** [December 1, 2023, 12:01pm UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/11 "2023-12-01T12:01:02Z")
Yeah this is a basic thing that we need our non technical users to be able to do easily in their personal views without having to write formulas ---
**Author:** ![Yuri\_BC](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yuri_bc/32/8803_2.png) [@Yuri\_BC](https://community.fibery.io/u/Yuri_BC)\ **Post date:** [April 17, 2024, 8:06pm UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/12 "2024-04-17T20:06:58Z")
Related > [@Ordering for Unsorted Entities](https://community.fibery.io/t/ordering-for-unsorted-entities/6086/1): > > Not a bug (I don’t think) but an annoying little issue I figured I’d bring up. We like to sort many things in the list view by dates (ascending), where the oldest thing is at the top of the list and the newest thing is at the bottom. For example: Entity 1 - Jan 1 Entity 2 - Feb 1 Entity 3 - Mar 1 Now, when a new entity is created and its date hasn’t been set yet, I want it to show up at the bottom of my list, but instead it always shows up at the top. So, expected: Entity 1 - Jan 1 Enti… ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [April 17, 2024, 8:51pm UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/13 "2024-04-17T20:51:32Z")
FYI when a topic in the community mentions another, this can be seen at the top of the topic being mentioned, ![1000019235](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/d/d0ba4cfd9f36a503812ff3fa08ba5915129e7d43.png) so it makes sense to check there before adding a ‘reverse’ mention ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [April 23, 2026, 2:48pm UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/14 "2026-04-23T14:48:02Z")
Now you can set where to show empty values in search results (top or bottom) [April 23, 2026 / Experimental UI pages creation via AI, Sort improvement](https://community.fibery.io/t/april-23-2026-experimental-ui-pages-creation-via-ai-sort-improvement/10763) ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [April 23, 2026, 2:56pm UTC](https://community.fibery.io/t/done-choose-order-of-empty-values-when-sorting-on-date-field/1019/15 "2026-04-23T14:56:13Z")