# 'MMM d, hh:mm:ss a' date format broke on Perspective table? **URL:** \ **Category:** Ignition Early Access\ **Created:** [February 10, 2020, 11:37pm UTC](https://forum.inductiveautomation.com/t/mmm-d-hhss-a-date-format-broke-on-perspective-table/32116 "2020-02-10T23:37:14Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![wking](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wking/32/21823_2.png) [@wking](https://forum.inductiveautomation.com/u/wking)\ **Post date:** [February 10, 2020, 11:37pm UTC](https://forum.inductiveautomation.com/t/mmm-d-hhss-a-date-format-broke-on-perspective-table/32116/1 "2020-02-10T23:37:14Z")
![wrongtime](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/0b8dd9a185315ddb0443e43f45f0c470514a27ef.jpeg) switched to ‘MM/DD/YYYY HH:mm:ss’ and see good behavior. What is weird is I have methods built off the props.data[0] of that row. And it uses the rendered value? instead of the good backend value. ![Screenshot%20(35)_LI](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/3f94bb92464f5dafeb2104b00a20e143850fe62f.jpeg) Same results in the browser as well. This date format has worked for me for a long time. ---
**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:** [February 11, 2020, 6:29pm UTC](https://forum.inductiveautomation.com/t/mmm-d-hhss-a-date-format-broke-on-perspective-table/32116/2 "2020-02-11T18:29:11Z")
Change the lower-case “d” in your format to “D”, or “DD”. moment.js defines “d” as the 0-indexed day of the week, where Sunday is “0”, and Saturday is “7”. “D” is the day of the month, so the the “8th” day of a month would be “8” with “D”, and “08” with “DD”.