AnsweredAssumed Answered

Calculate latest timestamp from records

Question asked by RedL on May 18, 2011
Latest reply on May 18, 2011 by RedL


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".