Skip to main content
matt
matt
Contributor ⭐️⭐️⭐️
August 13, 2019

Relative date/time in audience and account filters

  • August 13, 2019
  • 4 replies
  • 84 views
Hi,

Can PX filter the audience or account relative to a certain date? For example, can I filter "where trialEndDate less than $TODAY"? (unexpired trials) or "where trialEndDate equals $TODAY+5" (i.e. trial expires in the next 5 days)?

-Matt

      4 replies

      link_black
      link_black
      Gainsight Employee ⭐️⭐️
      August 13, 2019
      That does seem to be available.



      @alextran

      -- Link
      link_black
      link_black
      Gainsight Employee ⭐️⭐️
      August 14, 2019
      The first one seems possible using Audience logic such as the following:

      Upon further review, the second one does NOT seem possible without being able to change "days ago" to "days ahead".

      This would be a good enhancement to consider for improving the date filtering logic.

      @alextran @ciarapeter

      -- Link
      ciarapeter
      ciarapeter
      Contributor ⭐️⭐️⭐️
      August 23, 2019
      Matt - I'm adding this to our backlog, I agree it would be a great usability improvement.

        matt
        mattAuthor
        Contributor ⭐️⭐️⭐️
        August 27, 2019
        Thanks @ciarapeter

        Terms & ConditionsAccessibility statement