How to create a custom filter in a look that uses an OR statement

[JordanLo]

I’m trying to create a report that shows all loans where they had their promotional program end yesterday or their loan closed yesterday. But I don’t know what to write in the custom filter where it says (for example): subvention_end_date = yesterday OR loan_closed_date = yesterday. 

How do I show yesterday?

[fabio1]

Hi @JordanLo - Try using the `matches_filter` expression function to help with this:

https://docs.looker.com/exploring-data/creating-looker-expressions/matches_filter

For example:
matches_filter(${subvention_end_date},`1 day ago for 1 day`) or matches_filter(${loan_closed_date},`1 day ago for 1 day`)