# Power Table Date Format Bug?

**URL:** <https://forum.inductiveautomation.com/t/power-table-date-format-bug/42932>\
**Category:** Ignition\
**Created:** [February 3, 2021, 1:03am UTC](https://forum.inductiveautomation.com/t/power-table-date-format-bug/42932 "2021-02-03T01:03:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![brian.mcenulty](https://avatars.discourse-cdn.com/v4/letter/b/b77776/32.png) [@brian.mcenulty](https://forum.inductiveautomation.com/u/brian.mcenulty)\
**Post date:** [February 3, 2021, 1:03am UTC](https://forum.inductiveautomation.com/t/power-table-date-format-bug/42932/1 "2021-02-03T01:03:27Z")

</div>

I’ve got a power table with a time stamp column (smalldatetime type). The date format on this column is set to M/D/YYYY H:mm. Looking at the View Dataset and the actual table itself I’m seeing some odd dates in the table. Any ideas what may be wrong here? Version 8.1.1

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/5/1555c24320766c800edc24e0aa718a5cd879b173.png)

---

<div class="post-metadata">

**Author:** ![schenk](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@schenk](https://forum.inductiveautomation.com/u/schenk)\
**Post date:** [February 3, 2021, 2:10am UTC](https://forum.inductiveautomation.com/t/power-table-date-format-bug/42932/2 "2021-02-03T02:10:04Z")

</div>

The capital D in the format will give you the day of the year. Your [date format](https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html) should be something like `M/d/yyyy H:mm`.

---

<div class="post-metadata">

**Author:** ![brian.mcenulty](https://avatars.discourse-cdn.com/v4/letter/b/b77776/32.png) [@brian.mcenulty](https://forum.inductiveautomation.com/u/brian.mcenulty)\
**Post date:** [February 3, 2021, 3:19am UTC](https://forum.inductiveautomation.com/t/power-table-date-format-bug/42932/3 "2021-02-03T03:19:07Z")

</div>

🤦‍♂️ good catch, thank you!