Relative Date Custom Filter

[annie_bananie]

Hi, I am looking to build a daily report of findings where either the First Found Date or Reopened Date (2 different date fields) was in the past 1 complete day. I’m not sure how I would go about building a relative custom filter here…any suggestions?

[fabio1]

Hi @annie_bananie !

You can use the matches_filter function, inside of a custom filter, and or two of them together

Looker Documentation

matches_filter

Function: Compares a field's value to a custom filter expression.