11 Replies Latest reply on Mar 3, 2017 5:12 PM by Mia Lee

    Dates and pivoting to combine multiple dates field

    Béatrice LORIOT

      Hi all,


      i've seen a lot of questionning around "combining multiple field dates into one", and answers are always the same : either pivoting or doing some SQL. :-)


      But what do you do when you can't pivot or SQL ? Which is the case when being directy connected to a database which does not allow any of those.


      I have 4 fields :


      • Customers ID
      • Providers ID
      • Provider creation date
      • Customer creation date


      I would like to be able to count all providers and customer created during the same period and use one date filter. (month and Q)