Is there any way to write a SuiteQL formula in SuiteAnalytics that can detect if a certain date field falls under the date range specified under the date range filter?

I too wish to know this.