What is the best practice for setting an advanced filter that will always find things like "last month" and "2 months ago" based on the current date? I have tried certain things (like using the DateDif function) that only work in certain scenarios but not all scenarios. It seems like there are some methods that work well in a sql query that just are't options with Insights. Has anyone come across this or have a solution?
