How do I filter Date that is before yesterday?

[JohnnyPicnic]

I have a list of date/times and I want to filter/keep data that is before yesterday. In other words I don't want today or yesterday.
I found this Date.AddDays(Date.From(DateTime.FixedLocalNow()),-1) but not sure how to use it in the query.

 

[Matt Allington]

I always try to use the Ui to write the code, then edit it as needed. Manually add a filter upon the column in the UI, ie < anyDate. This will hard code a less than filter in the code. Replace the date with your code provided above. It should work.

 

[JohnnyPicnic]

I always try to use the Ui to write the code, then edit it as needed. Manually add a filter upon the column in the UI, ie < anyDate. This will hard code a less than filter in the code. Replace the date with your code provided above. It should work.

Thank you! I was able to get it with

= Table.SelectRows(#"Renamed Columns", each [Date modified] < Date.AddDays(DateTime.LocalNow(),-1))