it also gives me a syntax error for this line: " xfa.host.messageBox("The second date is earlier then the first date.\u000aThe date fields will reset.", "Information", 3, 1) " saying there is an error for "xfa"
When you say "same as above" do you mean I can just leave the previous equation I entered and not change anything as far as the field and coding? Also, when I input the new equation you gave me in numeric field called "Days Remaining" it gives me a syntax error for this line: "if (Date2Num(DateField19, "YYYY-MM-DD") < Date2Num(DateField3, "YYYY-MM-DD")) then" saying "syntax error near token "lt""
Awesome! I tried it and everything worked perfect! I have another equation that I need help with that is very similar to the previous one... I want to take a "Days Allowed" - (End Date - Start Date)= "Days Remaining" (I need it to be an integer, not a date). Thank you so much for your help!
The problem I am having is that I want the "Start Date" field and the "+1" "+2" "+3" etc. fields to be input at random. Each one of the integer fields would be a separate field that the user would enter a number into and it may not be the same number every time. It may be 1 or it may be 28. How do I get the form to auto calculate the "start date" plus the two other fields that are changed by the user (ie. "stop days" and "extension days") to get an "Estimated Completion Date"?