Skip to main content
matt
matt
Contributor ⭐️⭐️⭐️
Aug 13, 2019 1:05 AM UTC

Relative date/time in audience and account filters

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 ⭐️⭐️
      Aug 13, 2019 9:32 PM UTC
      That does seem to be available.



      @alextran

      Translate
      -- Link
      link_black
      link_black
      Gainsight Employee ⭐️⭐️
      Aug 14, 2019 1:52 AM UTC
      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

      Translate
      -- Link
      ciarapeter
      ciarapeter
      Contributor ⭐️⭐️⭐️
      Aug 23, 2019 7:10 PM UTC
      Matt - I'm adding this to our backlog, I agree it would be a great usability improvement.

      Translate
        matt
        mattAuthor
        Contributor ⭐️⭐️⭐️
        Aug 27, 2019 7:06 PM UTC
        Thanks @ciarapeter

        Translate
        Terms & ConditionsAccessibility statement