You need to use HubSpot lists for this, rather than contact views. In lists you can set up a rule stating ‘became MQL date is more than two weeks ago’ like this:
Thanks Phil, it hadn’t even occurred to me yet that you could filter for smart list membership on reports. Thought that was only under contacts tab. Thanks again!