Yes, I think that’s expected. If you make it a datetime column, then Glide will do its best to convert whatever you enter into a single datetime value. Have a browse through the below thread to learn more about that:
For your use case, it needs to be a text column.
What I would do is convert it to an integer using a math column, and store that in the array. Then use the Text to Date plugin to convert it back to a timestamp when it needs to be used. For the first step - assuming that you want to include minutes & seconds - then you could use the following formula:
Year(Now) * 10000000000
+ Month(Now) * 100000000
+ Day(Now) * 1000000
+ Hour(Now) * 10000
+ Minute(Now) * 100
+ Second(Now)
Then to convert that back later, use the Text to Date column with the following pattern:
yyyyMMddhhmmss
Here is how that would look:
