I am trying to call a pop-up and I need to use the timeE field as a param in it.
But when I use the props.selected.data[0] to pass the info in its structure is in text.
I realize I can use the index of the selected row and get from there and that is what I am doing. But, what if I needed multiple rows. Shouldn’t it come through as a DateTime value?
No worries! I did a workaround by adding another column with the date in millis and hid it. Then when passing the selection I had access to that which came over as an int just fine.
I'm having this issue in 8.1.39.
My database is PostgreSQL 15
My date column is timestamptz
It's a bit of effort for me to add the millis into the resurned data as there's a lot of dynamically created stuff... hoping that I can parse this ugly date/time format automatically to convert it back in my script...
Edit: parsing that time format seems harder than I thought, that and also it's probably showing the local browser's locale format as well in which case it might be different on every client...
Same issue here Ignition 8.1.31. This issue is affecting also in place editing, i.e. if the datetime cell is double-clicked for edit, the user is presented with the following odd date/time: