3 Replies Latest reply: Dec 18, 2012 9:33 AM by Jonathan Ditchfield RSS

    Calculate between date/time field and system time

      Hi,

       

      I am trying to set a calculated expression on a straight chart.  I have a date/time field called logdate in the following format (dd/mm/yyyy hh:mm:ss), and I want to be able to calculate the currently system time in the same format against the logdate field.  This should then show me the duration of when a call was logged to the current time. 

      Do you know what code I need to run?

       

      Regards,

       

      Jon Ditchfield