1 Reply Latest reply: Nov 15, 2016 1:11 PM by Stefan Wühl RSS

    Combine Date Fields

    Ismael Torres

      Hello,

       

      I have 3 date fields, Submitted Date, Approval Date, and Terminated Date. I have 3 columns in my table:

      Count (Submitted Date)

      Count (Approval Date)

      Count (Terminated Date)

       

      I would like to know if it is possible to have 1 date field that, I can filter by, that would affect all 3.

      For example if I choose 01/01/2016 on my new field it would filter the 3 dates for my table. I provided a screenshot of my table and the Date fields.

       

      The current behavior is that if I change my Approval Date to 01/01/2016 it filters my Total Approved column perfectly but not the others.

       

      Thank you,

       

      Ismael