Skip to main content

Relative date/time in audience and account filters

  • August 13, 2019
  • 4 replies
  • 75 views

matt
  • Contributor ⭐️⭐️⭐️
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
Forum|alt.badge.img+2
  • Gainsight Employee ⭐️⭐️
  • August 13, 2019
That does seem to be available.



@alextran


link_black
Forum|alt.badge.img+2
  • 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


ciarapeter
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️
  • August 23, 2019
Matt - I'm adding this to our backlog, I agree it would be a great usability improvement.


matt
  • Author
  • Contributor ⭐️⭐️⭐️
  • August 27, 2019
Thanks @ciarapeter