Perspective Table Date Column

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.



How did you solve for this?

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.

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.


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

Hey Phil,

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


1 Like