# Perspective Table Excluding 'AM and 'PM' When Using dateFormat

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-excluding-am-and-pm-when-using-dateformat/74981>\
**Category:** Ignition\
**Tags:** database, ignition81, perspective\
**Created:** [June 13, 2023, 8:18pm UTC](https://forum.inductiveautomation.com/t/perspective-table-excluding-am-and-pm-when-using-dateformat/74981 "2023-06-13T20:18:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Raymond\_Sipes](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@Raymond\_Sipes](https://forum.inductiveautomation.com/u/Raymond_Sipes)\
**Post date:** [June 13, 2023, 8:18pm UTC](https://forum.inductiveautomation.com/t/perspective-table-excluding-am-and-pm-when-using-dateformat/74981/1 "2023-06-13T20:18:22Z")

</div>

Hello!

I am having a hard time trying to get the dateFormat to return either 'AM or 'PM' when the `render` is set to `date`

I have the dateFormat set to `M/DD/YY HH:mm ` if I add the 'tt' as you would within a SQL query, it doesn't format as intended:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/f/6f8871f93578ef53df4c00db0e7b96077d2365e3.png)

I have also tried it with the pre-selected dateFormat of `MM/DD/YYYY HH:mm:ss` and added `tt` but still didn't produce the expected results.

Is this possible within the table component? If not, is there a possible workaround?

Thank you!

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [June 13, 2023, 8:23pm UTC](https://forum.inductiveautomation.com/t/perspective-table-excluding-am-and-pm-when-using-dateformat/74981/2 "2023-06-13T20:23:23Z")

</div>

Use `M/DD/YY HH:mm A`. Perspective uses [moment.js rules](https://momentjs.com/) for formatting dates

---

<div class="post-metadata">

**Author:** ![Raymond\_Sipes](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@Raymond\_Sipes](https://forum.inductiveautomation.com/u/Raymond_Sipes)\
**Post date:** [June 13, 2023, 8:24pm UTC](https://forum.inductiveautomation.com/t/perspective-table-excluding-am-and-pm-when-using-dateformat/74981/3 "2023-06-13T20:24:18Z")

</div>

Ah that was it! I knew it was something I was missing. Thank you so much for the quick response!