Skip to main content
candace_jones
candace_jones
Contributor ⭐️⭐️
February 1, 2016
Question

Date Filters Fail for Multiple Parameters

  • February 1, 2016
  • 2 replies
  • 54 views
Reports 2.0 fails when multiple date ranges are selected. For example, we are looking to run a report that is double-bound: renewals dates after today and less than next 90 days. When we select only one filter, we receive the expected results. However, when we select both filters, the report returns 0 results.

    2 replies

    manu_mittal
    Gainsight Employee ⭐️
    manu_mittal
    Gainsight Employee ⭐️
    February 1, 2016
    Hi Candace,

    If you are trying to filter for all renewals in the next 90 days, excluding today, something like this should work: "Renewal Date > Today" AND "Renewal Date = Next 90 days."

    Thanks,
    Manu
    candace_jones
    candace_jonesAuthor
    Contributor ⭐️⭐️
    February 1, 2016
    Hi Manu,

    Unfortunately, we tried that and it failed. We opened a support ticket and were told it is an overarching issue with the filter.
    Terms & ConditionsAccessibility statement