Is there something wrong with panel of choose date

Get Help
1

hi,bros.
when I do one same query,using date condition of var type text like "2018-12-23" to "2018-12-25"(picture 2) the result is different like use date panel(picture 1),is there something wrong with the return value of date panel.

thanks for heip!

6138BA94-4DEA-478c-B87B-B60F2981AD75
6138BA94-4DEA-478c-B87B-B60F2981AD751342×615 20.2 KB
B2DE4563-6951-49a1-8616-67D73D8DEDAC
B2DE4563-6951-49a1-8616-67D73D8DEDAC1352×596 19.8 KB

2

Hi @cedrus

Which version are you using? And which database are you connecting to?

I'm not quite sure what's going on, but can you check what actual query is by opening developer tools in the browser, go to Network tab, run the query again to make the POST request show, select the request, go to Response sub-tab, find data>native_form>query

image
image987×429 34.2 KB

(This is how it looks in Firefox - I think Chrome is similar, but might be slightly different)

2 Likes
3

@flamber Thanks for your help!My metabase version is v0.28.1.database is mysql.I got this by your way.
use var text
use_text
use date panel
use_date_panel

I think this differences lead to that result.
Thank Your.

4

Finally,i use STR_TO_DATE(BEGINDATE,"%Y-%m-%d") in my procedure to Solve this problem.

5

@cedrus
Great - it seems a little hacky, but as long as it works :slight_smile:
Do you know that Metabase 0.31.2 is the newest release? There’s a lot of changes since 0.28.1, so I cannot say for sure if your problem was fixed.

6

Yes,I do know my release is old.But its OK for date panel return UTC time format(it has more infomation),and I don’t think new release change this.I will try new release,because sometimes my metabase get stuck and run out my cpu.:disappointed_relieved: