Ok so you need extra columns to show weeks, months from a certain date.

Then you can filter the view based on how many weeks, months back you want to see.

Basically you need to use the DATEDIFF function in SQL

DATEDIFF( month, YourDate)

DATEDIFF( week, YourDate)

DATEDIFF( day, YourDate)

If you can show me the SQL for your view, I could amend it to show weeks etc difference unless you can work it out from this yourself

Then you can filter the view based on how many weeks, months back you want to see.

Basically you need to use the DATEDIFF function in SQL

DATEDIFF( month, YourDate)

DATEDIFF( week, YourDate)

DATEDIFF( day, YourDate)

If you can show me the SQL for your view, I could amend it to show weeks etc difference unless you can work it out from this yourself