Populate multiple date fields based on a status change in another field

I am trying to store and KEEP a date in a field based on the selection of a specific value in a separate picklist.  I have used IF statements to evaluate the picklist and then stored the value date values in separate GLOBAL variables.  The values get stored, but when the picklist value is changed and the same record is saved once again the original date field's value gets zeroed out.

As an example we have a picklist call 'Activity Status' and I would like to create a number of fields on our production report that would capture the date when specific values are saved in the status field - FOR ONE RECORD.
I.e.,
Create record with Status  'Built' value selected , user saves record and 'BuiltDate' field is updated with date from another field value;
Update that same record to Status  'Tested' value selected , user saves record and 'TestDate' field is updated with date from another field value; - and the first BuildDate field is still populated -
Update that same record to Status  'Shipped' value selected , user saves record and 'ShipDate' field is updated with date from another field value; - and all date fields are now populated.

The purpose of this is so we can create a report to manage our production on a daily/weekly or monthly basis

Any suggestions by the community would be greatly appreciated
haidentAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Are you trying to do this with Crystal?

Crystal is a reporting tool and is not really built to update a database.

mlmcc

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.