You'd need to post your script so that we can see the details. Also, is the Final_Date field a date field with an auto-entered caculation or is it a field of type calculation? Either way, posting that calculation could help as well.
I do something similar in one of my databases, but I use these two scripts:
Script 1 to save original value:
#This script saves the pre-edit value of the current field in a global field: $$OldValue. It is performed from an OnObjectEnter Trigger.
#Parameter: GetFieldName is used to pass the name of the field being entered as the script parameter.
Set Variable [ $$OldValue; Value:GetField ( Get ( ScriptParameter ) ) ]
Script 2 to confirm whether to save change or revert to original value
Set Variable [ $fieldName; Value:Get ( ScriptParameter ) ]
If [ not IsEmpty ( $$OldValue ) and ( $$OldValue ≠ GetField ( $fieldname ) ) ]
Show Custom Dialog [ Title: "Confirm Change"; Message: "Replace previous value with this change?"; Buttons: “Save”, “Revert” ]
If [ Get ( LastMessageChoice ) = 2 // Revert was clicked ]
Set Field By Name [ $fieldname; $$OldValue // revert field back to previous value ]
To post a script to the forum:
- You can upload a screen shot of your script by using the Upload an Image controls located just below Post A Answer.
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF to your clipboard for pasting here.
- If You have FileMaker advanced, you can generate a database design report and copy the script as text from there.
- If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional and easier to read format. (Use the HTML option on the database tab panel and paste the text into the forum's HTML editor.)