In one app I am using template for combining datetime&rowid. This i made correct with standard date formatting. In the set column value action after record adding I am copying this template field into spreadsheet text column. During this action Glide is changing the date format, making it unusable for sorting.
For sorting a datetime column, sometimes it’s helpful to create a “datetime numeric value” using math column:
year(date)*10000000000+month(date)*100000000+day(date)*1000000+hour(date)*10000+minute(date)*100+second(date)
1 Like
I am frustrated when I don’t solve such problem by myself! OK, 50 years ago I would do it in 1st minute. Maybe I am too much oriented on problem and not on solution: “I have problem for every solution!”.
But this is still the workaround why set column value converts one date format to another?
Finally it would be fine that such workarounds are somehow used to fill in the FAQ database.
