Date Comparison in Reports

Hi Kristin, try doing '= Current and Previous FQ' instead - this is often returns more accurate results.

If you're still not seeing it match up then check how your Fiscal Year/Quarter is defined in Salesforce (https://help.salesforce.com/apex/HTViewHelpDoc?id=setting_the_fiscal_year.htm). That's the setting this filter is working off of. Hope that helps!

I need to use "less than or equal to" because we may have renewal that are very past due. 

Our fiscal year is setup to start with Feb. So are QTRs are:
1=Feb-Mar-April
2=May-June-July
3=August-Sept-Oct
4=Nov-Dec-January

The filter Renewal Date <= Current FQ is not working correctly. Please have this further investigated.

thanks
Kristin

Thanks for the feedback, Kristin! We will get investigate this issue further and get back to you.

Kristin, I see the same behavior when I adjust my report to <= Current FQ.  Our Current FQ is Sept - Nov and I don't see anything beyond Sept 1.  (= Current FQ shows me dates in Sept - Nov)   I agree this looks like a bug. You might want to open a support case.

Thanks, all. A ticket has been opened for this and has been sent to engineering for review. 

The workaround for now is <Next FQ. 

Hi Team -

So here is a new wrinkle in this issue. The results you see in the Report Builder are different from what is returned on the Gainsight tab. I have the report in a dashboard, and even though the renewal date criteria is <Next FQ in the report, the dashboard does not return any Customers with renewal date past 11/01/2015.

I also tried Renewal Date < Current FQ OR Renewal Date = Current FQ. Again, it works in the Report Builder, but in the dashboard there are no results.

Please investigate.

Kristin

Hello all,

Did the support ticket get this all resolved for you? Or it it an ongoing issue?

The workaround is working, but there is still the issue of <= Current FQ not giving expected results.