Dynamic Date Ranges Using SQL Expressions In Insight (OBIEE)

OBIEE doesn't appear to have any dynamic date ranges as native functionality. You typically have to prompt date or add static values to limit date ranges. I've found a way to do this so thought I would share if others are experiencing the same issue.

If you want a report to default to the last n months or the last n days you will need to apply a filter and use the "SQL Expression". In the example below I want to show all page views that have happened in the last 30 days. I have added the activity field "Page View Date" to the filter and now I want to edit this.