Date Stamps based on progress in production

[scottvaughan]

I have 4 steps in my production process. I have a Step field and and a Status field. Example: Step 1, Ready; step 1 complete: Step 2, Ready; Step 2, Complete and so on. The Steps are listed in a pull down menu next to the Status field. As I moved through the production process I use those two field to indicate the progress. As I complete each step I want to stamp with the date a seperate field to indicate when each step was completed. My field calc is as follows:

If(Step="Step 1" and Status="Complete", Status(Currentdate), "")

So once those 2 fields equal the step being complete is stamps the time. How do keep the stamp once I go to step 2. Once I move from Step 1 to 2, the field become empty for Step 1. I know why that is, but how, once the field is staped do I keep it static?

[-Queue-]

Are you using 5 or 5.5? In 5.5, you can use GetField( ) to grab the field's current value. If not, then you will probably have to script setting the date fields.

[scottvaughan]

I am using 5. What I have basically works but once I change a step, the date disappears from the previous step. I need to somehow keep the date once I change steps. What i would like to have is a date field for each of the 4 steps in my process. Each of those fields would have the date the step was completed automatically entered into it based on a combination of values from 2 pull down menus. One menu would likst the 4 steps, the other would like ready or complete.

[-Queue-]

Since you cannot self-reference a field in a calculation in 5, I do not think this can be done using only fields.

[comment]

See if the attached file helps.

trackPhase.fp3.zip