Auto Email AR report

I’m trying to setup an auto email report but need to know how do I make the date as of “Today” when it sends. If I want to send a report every Friday for AR, it should show me everything past due as of that date - not a hard coded date. Note: “As on date” but what’s the point if I have to change this every week? I might as well just run the report myself each week.