Filter Date dynamically

Feature Requests
1

I would love the ability to filter date fields dynamically with choices like:

Date is before 1 Month

Date is before 1 Week

or

Date is Before n Days/Months/Weeks etc...

Right now my only choice for something along these lines is putting in a specific date every time (mm/dd/yyyy) which means I can't do this on the data source page of a table view.


2

Along this same theme, I would like to be able to filter by a date range, such as Date is between 1/2/2016 and 2/15/2016 (inclusive). I know that this can be done by applying two different filters (Date is before 2/16/2016 and Date is after 1/1/2016), but that is cumbersome.