3 Replies Latest reply on Oct 16, 2018 8:00 AM by arvindgarg

    As of Date filter

    Paul Kim

      Hi,

      I'm trying to create a date filter for the table in the attachment. Based on the "Reference" Date , what I'd like for it to do is based on the entered "Reference" date, if an account has at least one activity that is on or after the "Reference" Date, the account should remain on the table, regardless if there might not be dates for the other activities. Conversely, if any activities (and nulls) fall before the Reference Date, then it should not be in the table. And if there are no dates, such as for eBay, then it should not appear as well.

       

      I tried to use a parameter but can't quite get this to work. It seems the "Reference" Date overrides the date filter ("On or After") and so eBay still appears. Does anyone have other suggestions on how to address this?

       

      Thank you!