I'm new to Lotus programming, and I need a solution ASAP.
I inherited a Notes 6.5 approval database with a problem in the approval date field. This approval database was in use for a few years before the programmer inserted a field called Approval date. The approval date reads a status field, and when status=3, the Approval date field populates with the moment that the document was approved. This works fine for new approvals.
There is a problem, however, with old approved documents.
When you open a document that is older than the day than the status field was introduced, the formula in the approval date recalculates, and the old approval date is replaced with today's date (the moment you opened it)
I need to ensure that the old approval dates remain, that approval dates are calculated only once, and that the approval date cannot be changed once the doc was approved.
Approval_date is a computed Date Time field with the following formula : @If(status=3;@Date(@Today);"")