1 Reply Latest reply: Feb 13, 2016 9:48 AM by Gysbert Wassenaar RSS

    Dates filter out by Selection

      Hi All,


      I have three dates here; orderdate, billdate, and paymentdate. I have to use SET analysis and need to filter out these dates according to the selection please help. I am new to SET Analysis. Can someone help me apply the below filters in SET.


      Thanks in advance,

      1) orderdate <= selected year/month or is null
      billdate >= selected year/month or is null
      3) Transaction billed GrossAmount is not $0
      4) paymentdate is in the selected year/month
      5) GrossAmount = > Contractlinebilling