# Ui-table date sort

**URL:** <https://discourse.nodered.org/t/ui-table-date-sort/21685>\
**Category:** FAQs\
**Created:** [14 February 2020 08:59 UTC](https://discourse.nodered.org/t/ui-table-date-sort/21685 "2020-02-14T08:59:39Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bobo](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bobo/32/8401_2.png) [@Bobo](https://discourse.nodered.org/u/Bobo)\
**Post date:** [14 February 2020 08:59 UTC](https://discourse.nodered.org/t/ui-table-date-sort/21685/1 "2020-02-14T08:59:39Z")

</div>

Anyone know of a neat trick to get a ui-table to do sorting by date, rather than standard numeric sort?

Thanks

---

<div class="post-metadata">

**Author:** ![Christian-Me](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/christian-me/32/10774_2.png) [@Christian-Me](https://discourse.nodered.org/u/Christian-Me)\
**Post date:** [14 February 2020 09:40 UTC](https://discourse.nodered.org/t/ui-table-date-sort/21685/2 "2020-02-14T09:40:55Z")

</div>

Hmm not tested but should be possible:

> **[Tabulator - Interactive JavaScript Tables](http://tabulator.info/docs/4.0/sort#func-builtin)**
>
> Create interactive data tables in seconds with Tabulator. A lightweight, fully featured JavaScript table generation library.

As you can configure ui-table using ui\_config there is certainly a way.  
Is your data a string or a unix timestamp?

---

<div class="post-metadata">

**Author:** ![Bobo](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bobo/32/8401_2.png) [@Bobo](https://discourse.nodered.org/u/Bobo)\
**Post date:** [14 February 2020 09:46 UTC](https://discourse.nodered.org/t/ui-table-date-sort/21685/3 "2020-02-14T09:46:35Z")

</div>

> [@Christian-Me](#):
>
> Tabulator - Interactive JavaScript Tables

Some reading for weekend, thank you. 😜

> [@Christian-Me](#):
>
> Is your data a string or a unix timestamp?

String

---

<div class="post-metadata">

**Author:** ![Christian-Me](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/christian-me/32/10774_2.png) [@Christian-Me](https://discourse.nodered.org/u/Christian-Me)\
**Post date:** [14 February 2020 11:04 UTC](https://discourse.nodered.org/t/ui-table-date-sort/21685/4 "2020-02-14T11:04:24Z")

</div>

A quick jump start .... This should handle your Sting - depending moment.js defined input / output format

```auto
{
    "tabulator": {
        "columns": [
            {
                "title": "Time",
                "field": "timestamp",
                "width": 100,
                "formatter": "datetime",
                "formatterParams": {
                    "inputFormat": "YYYY-MM-DD HH:mm:ss.SSS",
                    "outputFormat": "HH:mm:ss",
                    "invalidPlaceholder": "(invalid time)"
                }
            }
        ]
   }
}

```

---

<div class="post-metadata">

**Author:** ![Bobo](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bobo/32/8401_2.png) [@Bobo](https://discourse.nodered.org/u/Bobo)\
**Post date:** [14 February 2020 14:22 UTC](https://discourse.nodered.org/t/ui-table-date-sort/21685/5 "2020-02-14T14:22:37Z")

</div>

Thank you. Appreciate it.

---

<div class="post-metadata">

**Author:** ![Bobo](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bobo/32/8401_2.png) [@Bobo](https://discourse.nodered.org/u/Bobo)\
**Post date:** [15 February 2020 05:00 UTC](https://discourse.nodered.org/t/ui-table-date-sort/21685/6 "2020-02-15T05:00:38Z")

</div>

So just to close this out. What worked for me (bearing in mind this was date only, no time) was -

```auto
{
    "tabulator": {
        "columns": [
            {
                "sorterParams": {
                    "format": "DD/MM/YY"
                },
                "title": "Date",
                "field": "input_date",
                "width": 100,
                "sorter": "date"
                }
            }
        ]
   }
}

```

@Christian-Me thanks for showing me the way! 🙂

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [29 February 2020 05:02 UTC](https://discourse.nodered.org/t/ui-table-date-sort/21685/7 "2020-02-29T05:02:59Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.