Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events

Calculate the days between two dates in a third field


Level 2


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?


1 Reply


Level 10

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