Date time in Date Field Filter

dennypradipta · January 24, 2023, 9:01am

I am currently using MongoDB as the data source for Metabase. I have this native query where I can filter out the data based on the Date type Field Filter.

Is there any way I can set the time? Because I can only select the date right now.

TonyC · January 25, 2023, 12:03pm

Currently not. There’s a request open for support time based filter:

github.com/metabase/metabase

Support time in date parameters

opened 08:33AM - 24 Apr 18 UTC

petar777

Reporting/Dashboards Type:New Feature Querying/Parameters & Variables Querying/Native .Completeness

Hello, When I create a custom question I am capable of setting not only the d…ate but the time in my date filter too. To be more precise- I choose the date column which I want to use. Then select "Between" from the drop-down menu where the user chooses the options of the date filter. Once there, I can set the date but beneath of the date, I can see an "Add Time" option. This feature works perfectly and is very useful... However, if I want to create a more complex query and add a date variable or field filter, which I will later on control via the dashboard filter- I am not able to see the "Add Time" option no matter what I select from the drop-down menu. Is it possible to manually select time from a dashboard filter or SQL field filter? All the best :) :arrow_down: Please click the :+1: reaction instead of leaving a `+1` or `update?` comment

The work-around would be to split the date and time in two filters, and have the time-filter just being a simple Text-filter, where you manually write hour or hour-minute.

dennypradipta · January 25, 2023, 2:12pm

It's a little bit tricky because I have a dashboard with questions made both using the interface AND the native questions. I guess I can't use dashboard filters right now. Thanks for the reply