# Power Table Start and End Times Using Memory Tags

**URL:** <https://forum.inductiveautomation.com/t/power-table-start-and-end-times-using-memory-tags/58060>\
**Category:** Ignition\
**Created:** [April 5, 2022, 6:17pm UTC](https://forum.inductiveautomation.com/t/power-table-start-and-end-times-using-memory-tags/58060 "2022-04-05T18:17:44Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![beckya](https://avatars.discourse-cdn.com/v4/letter/b/b5a626/32.png) [@beckya](https://forum.inductiveautomation.com/u/beckya)\
**Post date:** [April 5, 2022, 6:17pm UTC](https://forum.inductiveautomation.com/t/power-table-start-and-end-times-using-memory-tags/58060/1 "2022-04-05T18:17:44Z")

</div>

I have 2 memory tags which contains a start and end date time of when a certain function was ran on a machine. I’d like to be able to report on other tag values and their timestamps between the start time and end time, which are both in the memory tags. I tried to create this report in a perspective table component but the memory tag date and time is showing up as null when I try to bind it. Is there something I can do to fix this?

Any advice would be helpful. I am open to other ideas too.

---

<div class="post-metadata">

**Author:** ![andrews](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@andrews](https://forum.inductiveautomation.com/u/andrews)\
**Post date:** [April 5, 2022, 6:42pm UTC](https://forum.inductiveautomation.com/t/power-table-start-and-end-times-using-memory-tags/58060/2 "2022-04-05T18:42:14Z")

</div>

How are you “binding” it?

---

<div class="post-metadata">

**Author:** ![beckya](https://avatars.discourse-cdn.com/v4/letter/b/b5a626/32.png) [@beckya](https://forum.inductiveautomation.com/u/beckya)\
**Post date:** [April 5, 2022, 6:57pm UTC](https://forum.inductiveautomation.com/t/power-table-start-and-end-times-using-memory-tags/58060/3 "2022-04-05T18:57:40Z")

</div>

First I tried binding it as a start date and end date in the tag history binding and was confused why the data wouldn’t filter on those dates.

Then I tried binding it to a date time picker and saw the value is null for if I bind to the value or if I bind to the formatted value.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 5, 2022, 7:04pm UTC](https://forum.inductiveautomation.com/t/power-table-start-and-end-times-using-memory-tags/58060/4 "2022-04-05T19:04:39Z")

</div>

Are there permissions on the tags?

---

<div class="post-metadata">

**Author:** ![beckya](https://avatars.discourse-cdn.com/v4/letter/b/b5a626/32.png) [@beckya](https://forum.inductiveautomation.com/u/beckya)\
**Post date:** [April 5, 2022, 7:07pm UTC](https://forum.inductiveautomation.com/t/power-table-start-and-end-times-using-memory-tags/58060/5 "2022-04-05T19:07:23Z")

</div>

No, no permissions

---

<div class="post-metadata">

**Author:** ![beckya](https://avatars.discourse-cdn.com/v4/letter/b/b5a626/32.png) [@beckya](https://forum.inductiveautomation.com/u/beckya)\
**Post date:** [April 5, 2022, 7:09pm UTC](https://forum.inductiveautomation.com/t/power-table-start-and-end-times-using-memory-tags/58060/6 "2022-04-05T19:09:05Z")

</div>

I wondered if it has to do with the format of the date time, when i click on the value it changes to this: Tue Apr 05 12:09:11 CDT 2022 instead of being in the yyyy-MM-dd h:mm:ss aa format that the tag is in.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 5, 2022, 7:48pm UTC](https://forum.inductiveautomation.com/t/power-table-start-and-end-times-using-memory-tags/58060/7 "2022-04-05T19:48:31Z")

</div>

Is the tag a string? It should be a DateTime.

---

<div class="post-metadata">

**Author:** ![beckya](https://avatars.discourse-cdn.com/v4/letter/b/b5a626/32.png) [@beckya](https://forum.inductiveautomation.com/u/beckya)\
**Post date:** [April 5, 2022, 7:49pm UTC](https://forum.inductiveautomation.com/t/power-table-start-and-end-times-using-memory-tags/58060/8 "2022-04-05T19:49:52Z")

</div>

no, it is datetime
