Re: Stop counting duration

LB,

I think the most reliable way to record the date that the status is changed will be to change that status field properties to log changes. That way the date will be captured with the status. Then we will need a formula to par so the most current status and another formula to parse out the date of the most current status.

field properties to log changes. That way the date will be captured with the status. Then we will need a formula to par so the most current status and another formula to parse out the date of the most current status.

I am going to paste damn sheet notes to myself for how to parse out who did the update. What the most recent update was, and the date of the most recent update. So the idea is that you would change your existing field properties to log changes. Leave it at the default setting, which is too long new items at the bottom. And do not capture the time. 

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))

then you should be able to use Garry's formula. Post back if you get stuck.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------