Date Calculation

B

Bryan Hughes

Hello,

I am building an annual employee evaluation form. How can take the a Date
from one node (myStartDate), replace the year of myStartDate with the
current year, place that in a node (myEvalDate1), then add 1 year to the
myEvalDate1 and place that result in a node (myEvalDate2)?

-TFTH
Bryan
 
A

Arul

May not be best solution but will get you to the end result.

Create two date fields and two text boxes. The first date field =
myStartDate. In the second date field, use the formula to set the "Default
value" to "Today()". In the first text box (myEvalDate1), use the formula to
set the "Default Value" to substring(field2, 1, 4)...where field2 is the
second date field. In the second text box (myEvalDate2), use the formula to
set the default value to myEvalDate1+ 1.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top