You create formula fields to hive off the information from the most recent update and use those fields in View mode on forms and on reports.
Here are the essential formulas.
Parsing Append Only Fields
so... if you have a text field set to Log Changes where the new entries act in the default manner which is to be at the bottom of the updates, here are some formuals to use to parse out the values from the most recent entry. I am also assuming that you are logging the date and not the date and time.
Most recent value (formula text field type)
Trim(Right([my update field],"]"))
Date of most recent update (this needs to be a formula date field)
ToDate(Left(Right([my update field],"["),9))
Who did the most recent update (formula text field type)
Trim(NotLeft(Left(Right([my update field],"["),"]"),9))
thanks, actually got that working with the log field. i am getting the date of a specific satus what is the formual to get the user name? can't seem to get that right. this is what i am using to get date of WIP