1 Reply Latest reply on Jul 5, 2018 2:45 PM by Galen Busch

    Average of dates

    rajesh.nomula.0

      Hi,

       

      I have a situation here. I have a two dates, x-date and y-date. i have to do a datediff between these two dates, which is pretty much straight forward. But the problem is i have multiple x-dates for single row. I have to get average of x-date and do datediff between avg(x-date) and y-date. how to get this.

       

      help

       

       

       

      row 1 .       name       value .  

      ID
      Name
      x-date
      Y-date
      1michel

      23-4-2018  7:30 PM

      23-4-2018  7:45 PM .        I have to get average of

                                                 three dates and do datediff with y-date

      23-4-2018  8:00 PM

      30-6-2018 8:00

      2adam

      30-5-2018 2:00 PM

      30-5-2018 6:00 PM

      31-5-2018 4:00 PM

      1-7-2018 7:00
      3jenny