Forum Discussion
Capture Actual Date Task Was Checked Off
Is there any way to capture when a task was actually checked off using either a custom formula or maybe some fields I am not aware of? Or what about Finish Variance? Is there a way to use that field to see the difference between when a tasked was checked off vs Finish Date? Thanks for any help or suggestions!
7 Replies
- Jamie Salbeck,
Is there a way? Yes, but it would require using an event based macro to capture the current date based on the task being marked as complete. The same with the Finish Date or Variance.
John- Thanks, do you have any insight on how I might go about creating the macro?
- Jamie Salbeck,
Sure, here is an article on how to set up the project change event. You need to be careful when using the change event so it is isolated to fire only when a specific change occurs, like when percent complete equals 100%.
https://learn.microsoft.com/en-us/office/vba/api/project.project.change
