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

    Dates filter out by Selection

    Arsalan Qureshi

      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
      2)
      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