Command Button to filter subform between dates formula

Hi DBer's

I need to have a command button that filters a subform between dates based on this formula

Between (=Date()-Weekday(Date())+2) AND (=Date()-Weekday(Date())+7)

The field that it picks from is a field called [Job Date}

So I would think the code would be something like;

Me.[subformname].Form.Filter = "Job Date = #" Between (=Date()-Weekday(Date())+2) AND (=Date()-Weekday(Date())+7)

But that doesn't work