6 Replies Latest reply on May 18, 2011 12:02 PM by RedL

    Calculate latest timestamp from records



      Calculate latest timestamp from records


      I have "Sales Order table" with "Sales Order Detail" table which has detail SKU info for each Sales Order.  I have Auto Enter Modification Time Stamp field on each line.  I need to find the latest modification timestamp for each Sales Order.  Following is what I do.
      On "Sales Order" I create one calculation filed: Max ( SO_SalesOrderLine::_timestamp_modify )
      And I cannot show the maximum time stamp on the layout.  No matter the calculation result is timestamp or text.  On the layout, I try General and As entered for the field "Data formatting".