Although this is a repeated question but could not find the solution
@maz can you help me out
I have used a very simple query where it fetching only one date field jiraissue.created
Hi @emon8972
Which version of Metabase?
Can you give a little more context.
Are you using Custom Question or Native Question?
Is it a Nested Query aka Saved Question?
What does the result look like if you run the question and choose Table as visualization? Meaning, does it return a column cast as DATE
or DATETIME
?
Hi @flamber
Metabase Version- v0.30.0
Custom Query
Its a simple query. Actually I want to know how I can set the filter in the dashboard.
Its returning the datas in date-time format
@emon8972
That latest version is 0.31.2 and a lot of changes happened between 0.30.0, so I would recommend that you upgrade.
You’re saying it’s a Custom Query (Query Browser), but the screenshot is Native Query (SQL)
My first guess is that the Field Type is set to something that breaks the DateTime - try setting it to Creation Date
or Creation Timestamp
Settings > Admin > Data Model > (database) > (table) > (column)