# Perspective Table Date Column

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-date-column/35797>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [June 18, 2020, 2:05pm UTC](https://forum.inductiveautomation.com/t/perspective-table-date-column/35797 "2020-06-18T14:05:47Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![kyle.lawson](https://avatars.discourse-cdn.com/v4/letter/k/6de8d8/32.png) [@kyle.lawson](https://forum.inductiveautomation.com/u/kyle.lawson)\
**Post date:** [June 18, 2020, 2:05pm UTC](https://forum.inductiveautomation.com/t/perspective-table-date-column/35797/1 "2020-06-18T14:05:47Z")

</div>

On the perspective table component i have a column that is of a date/time datatype. I want this to be editable but when the user goes to edit, rather than display a calendar picker it wants a numerical entry. See image below.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/0ded9fe1b672a26cf45aa95a00e389a8020cde3d.png)

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [February 16, 2023, 2:52am UTC](https://forum.inductiveautomation.com/t/perspective-table-date-column/35797/2 "2023-02-16T02:52:28Z")

</div>

How did you solve for this?

---

<div class="post-metadata">

**Author:** ![nideyijuyidong](https://avatars.discourse-cdn.com/v4/letter/n/7cd45c/32.png) [@nideyijuyidong](https://forum.inductiveautomation.com/u/nideyijuyidong)\
**Post date:** [February 16, 2023, 9:03am UTC](https://forum.inductiveautomation.com/t/perspective-table-date-column/35797/3 "2023-02-16T09:03:04Z")

</div>

Format a datetime as a string with a script. It's kind of bad for operators, but developers can easily convert strings back to datetimes.

---

<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:** [February 16, 2023, 1:26pm UTC](https://forum.inductiveautomation.com/t/perspective-table-date-column/35797/4 "2023-02-16T13:26:31Z")

</div>

> [@nideyijuyidong](#):
>
> but developers can easily convert strings back to datetimes.

Mwah, ha, ha, ha!

No, they cannot, in my experience. And should not, since you inevitably end up with timezone issues. Use a view for that column display, and put a date picker in side.

---

<div class="post-metadata">

**Author:** ![nideyijuyidong](https://avatars.discourse-cdn.com/v4/letter/n/7cd45c/32.png) [@nideyijuyidong](https://forum.inductiveautomation.com/u/nideyijuyidong)\
**Post date:** [February 16, 2023, 2:58pm UTC](https://forum.inductiveautomation.com/t/perspective-table-date-column/35797/5 "2023-02-16T14:58:46Z")

</div>

Your suggestion is better, I forgot about time zone issues, my business has not expanded to other time zones.

---

<div class="post-metadata">

**Author:** ![dillon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dillon/32/81537_2.png) [@dillon](https://forum.inductiveautomation.com/u/dillon)\
**Post date:** [May 9, 2023, 8:35pm UTC](https://forum.inductiveautomation.com/t/perspective-table-date-column/35797/6 "2023-05-09T20:35:38Z")

</div>

Hey Phil,

To your knowledge, is this still the best way to edit a dateTimeStamp column in a table?

---

<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:** [May 9, 2023, 8:38pm UTC](https://forum.inductiveautomation.com/t/perspective-table-date-column/35797/7 "2023-05-09T20:38:17Z")

</div>

Yes.