How do i sort a table by date , when the date is in string format (metadata-array)?

i am unable to sort a table because the date is in string and it was a part of the an array that looked like this - {lastsignup: "abc", createdat: "abc"}. i could access the created at date in the column settings using {{self.createdat}} but clicking on the column doesnt sort it correctly .

Hi @sarthak!

Unfortunately, the sorting is using the original value of the column and not its mapped value. One option would be to transform this data before it enters the table to only have the created_at value. Another would be to create a custom column that references the createdat value from that row. Something like this: