Filter by time range

Follow

Ben Ohashi

• October 25, 2020 20:14

How do you filter by time range? 

I am trying to filter using a date field that includes time to rows that are between a certain timeframe, in this case between 7am-7pm. 

 

0

• 

  Brooks Duggan

  • November 11, 2021 20:58

  Hey Ben,
  
  Probably the best way to do this is through the SQL transformation, from what I can tell you will want to put:

  SELECT * FROM report where "date_created"::time between '07:00:00' and '19:00:00';

   

  This will filter out any data that is not between your specified time.

  0

  Comment actions Permalink

Please sign in to leave a comment.