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