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