How do I copy a date from one field to another, but only on the Insert action?

I want to copy the date from one field to another field ONLY on the initial entry, but not for subsequent changes. I am trying to track changes to a Complete date. Use case: A person enters an EST COMPLETE DATE of 12/20/24. A date is copied to a field called ORIG COMPLETE DATE. If the person changes the EST COMPLETE DATE, it does not change the ORIG COMPLETE DATE field. This way I can track the original complete date and the new complete date without having a secondary field of entry for the user.

EST COMPLETE DATE | ORIG COMPLETE DATE

12/20/24 12/20/24

They come and modify the EST COMPLETE DATE, and the ORIG COMPLETE DATE remains the same.

EST COMPLETE DATE | ORIG COMPLETE DATE

12/15/24 12/20/24

Best Answer

Answers