Calculate the days between two dates in a third field




I am using Adobe Livecycle Designer ES4.  I am making a travel form for my company.  The form has two date fields “BeginDate” and “EndingDate”.  I would like to calculate the days between the two dates in a third field called “TotalDaysOfTravel”.  I would also like to have something setup that if the employee choses a date in the  “BeginDate” field that is later than the one in the “EndingDate” field that it would give a warning “The ending date is earlier than the beginning date.”  The field should be setup to calculate the “TotalDaysOfTravel” automatically if anything in the two date fields change.

Could someone help me set this up?


Accepted Solutions (0)

Answers (1)

Answers (1)




This isn't that complicated.

In the field "TotalDaysOfTravel" add the following FormCalc script in the calculate event:

var datePattern = "MM/DD/YYYY" /if neccessary change the pattern to the format you use to display your dates

var startDate = Date2Num(BeginDate.formattedValue, datePattern)

var endDate = Date2Num(EndingDate.formattedValue, datePattern)

var numOfDays = endDate - startDate +1

$ = numOfDays