From the Results, create a report and for the 'run date' click the filter checkbox and put = "yesterday". If you only want the ones that didn't pass, Check the filter on Result and put <> "Passed"
Create a test suite using this report as your Data Profile. You can also filter location to get only results from a certain folder.
I need to re-execute a set of failed test modules that were run yesterday. I've tried to create a dynamic test suite but I don't know how to filter "yesterday"