troubleshooting Question

older Approval Date is overwritten with Today's date

Avatar of everetjo
everetjo asked on
Lotus IBM
17 Comments1 Solution408 ViewsLast Modified:
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);"")
Sjef Bosman
Groupware Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 17 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros