7 Replies Latest reply on Mar 18, 2016 3:30 PM by vinvivek

    How would you calculate the difference between two dates with time?

    posborne Apprentice

      I am attempting to calculate the difference between two date time fields, then take that difference and make it show as Breached or Met on a pie chart in a dashboard, based on if it is greater or less than 24 hours.

       

      Date 1: March 13, 2016 3:00 PM

      Date 2: March 14, 2016 4:00 PM

      The difference is 25 hours, so it should show as Breached in the Pie Chart as it is over 24 hours.