No valid Field Issue


#1


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


#2

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?


#3

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


#4

@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) :gear: