# 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:** 1\
**Showing post:** 4

<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)"
                }
            }
        ]
   }
}

```

---

_[View the full topic](https://discourse.nodered.org/t/ui-table-date-sort/21685)._