5 Replies Latest reply on Jan 19, 2017 4:03 AM by okramis

    Use ExecuteSQL to sum time fields

    thehalpeen

      I'm trying to sum a column of time fields in a set of records:

       

      I'm using the following formulas:

       

      ExecuteSQL ( "SELECT sum NUMVAL(TotalTime) FROM Events"; "" ; "")

       

      or

       

      ExecuteSQL ( "SELECT sum (TotalTime) FROM People_Shifts"; "" ; "")

       

      Note: The field 'TotalTime' is a time field.

       

      Neither of these work - I'm getting a '?'.

       

      Can we add time fields using ExecuteSQL?