# Date in UI Table

**URL:** <https://discourse.nodered.org/t/date-in-ui-table/37610>\
**Category:** Dashboard\
**Created:** [17 December 2020 03:12 UTC](https://discourse.nodered.org/t/date-in-ui-table/37610 "2020-12-17T03:12:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![marwinwijaya](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/marwinwijaya/32/23923_2.png) [@marwinwijaya](https://discourse.nodered.org/u/marwinwijaya)\
**Post date:** [17 December 2020 03:12 UTC](https://discourse.nodered.org/t/date-in-ui-table/37610/1 "2020-12-17T03:12:47Z")

</div>

Hello, I am Arwin. I want to ask about UI Tables. I have data on Mysql in year-month-date format, but when the display format changes to something like the following image, how do I change it to a format like mine? Thank you very much

 ![Prob 3](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/9/c95bbe8ba659be1b1896bb013652903a6ceca063.png)

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [17 December 2020 10:34 UTC](https://discourse.nodered.org/t/date-in-ui-table/37610/2 "2020-12-17T10:34:37Z")

</div>

1. Put a `debug` node on the output of the mysql node and show us what the data looks like.
2. what is the format of the date column - in the mysql database - defined as?

---

<div class="post-metadata">

**Author:** ![marwinwijaya](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/marwinwijaya/32/23923_2.png) [@marwinwijaya](https://discourse.nodered.org/u/marwinwijaya)\
**Post date:** [19 December 2020 09:46 UTC](https://discourse.nodered.org/t/date-in-ui-table/37610/3 "2020-12-19T09:46:35Z")

</div>

![Screenshot_1](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/6/b6a44d6db8ff408c04df3f0d912ed66eb8866547.png)

My output MySQL node on debug

---

<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:** [19 December 2020 15:39 UTC](https://discourse.nodered.org/t/date-in-ui-table/37610/4 "2020-12-19T15:39:57Z")

</div>

Tabulator (the base of ui-table) has so called formatters for this. Perhaps this thread can help:

> [@Ui-table date sort](https://discourse.nodered.org/t/ui-table-date-sort/21685):
>
> 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:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [18 January 2021 15:39 UTC](https://discourse.nodered.org/t/date-in-ui-table/37610/5 "2021-01-18T15:39:59Z")

</div>

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