Please see attachments. I have a column with a UNIX timestamp (example: 1633017668565) that I would like to display as date & time. However in the column settings, Data > Column Type, the options for both 'Date' and 'DateTime' are exactly the same. Is this a bug? I expected to see an option in 'DateTime' where I could format the strings as readable dates. Not quite sure how to accomplish this otherwise as the table source is a Google Sheet that is updated in realtime without the ability to format the date there.
Unfortunately there is no option to add custom date/time formats but you can choose the available formats from the general settings and they will be applied to the datetime column.
Please see attachments. I have a column with a UNIX timestamp (example: 1633017668565) that I would like to display as date & time. However in the column settings, Data > Column Type, the options for both 'Date' and 'DateTime' are exactly the same. Is this a bug? I expected to see an option in 'DateTime' where I could format the strings as readable dates. Not quite sure how to accomplish this otherwise as the table source is a Google Sheet that is updated in realtime without the ability to format the date there.
Hi Adam
Thank you for reaching out to us.
Unfortunately there is no option to add custom date/time formats but you can choose the available formats from the general settings and they will be applied to the datetime column.