Formatting table columns as date when asking a question

1

Hey there, I am new to Metabase and tried to resolve the issue on my own by using this forum and Google but weren't able.

I am asking a question and the result includes a timestamp column (Created) which should be displayed as date format. The table formats as integer. I then tried to select the right format under Admin Panel > Data Model > Table > Unix Timestamp (seconds) but that doesn't helped.

image
image1312×1898 195 KB

What should I do? Thanks!

2

Hi, have you tried formatting the date in sql as date(created)? That works for me:

image

Cheers, Eva

3

Thanks - seems like its only on that particular view. Once I asked the question, the column is displayed correctly. Though it confused me…

1 Like