For example, if you have a report that groups by a date field, you must use Between to get the correct date range for Salesforce objects. For a similar report on an MDA object, Between doesn't work. You have to add two filters: date field >= lower part of your range and date field <= upper end of the range.
If you try to apply the second method to Salesforce objects, it doesn't work.
Has anyone else run into this? I logged a case (9655) but got this feedback...
This is NOT considered as a bug because most of the use cases involve only one date in the filters like Date >= 1/1/2016 and Summarization is applied on it. Then as per the design, we summarize the data as Q1 2016 to Q1 2017( But not till March 2017, only till some specific months)