2 Replies Latest reply on Jul 28, 2016 11:06 AM by mark.welsh

    Datediff with more precise minutes?

    mark.welsh

      I'm trying to use DATEDIFF on two datetime fields to come up with a precise difference in minutes.  Using datediff only, I get the difference in whole minutes, seconds excluded.  So, I attempted to take the difference in seconds and divide by 60, but then I get an "incorrect data type" error on my view, and I must convert the measure from continuous to discrete which seems to make me unable to plot the measure on a vertical column chart - this could easily be user error.

       

      How do I get the difference between two datetimes in minutes that are not whole numbers, but decimals based on seconds?  And be able to plot on a vertical column chart with Days on columns and a sum of minutes on rows.