Expression for Total Days

Karan Fielding

I created a Conference Request form (Confi Forms) and am using a Simple Date field type to capture the startdate and enddate (field names). I would like the next field (totaldays) to auto populate the total days.

startdate to enddate = totaldays (how many days our employee will be gone to the conference)

I set totaldays to a Calculated field type and am hoping there's a simple expression that I can add to do the math.

 

Davin Studer

If your users might edit the entry after it is created then you would want to use a formula type instead. Calculated fields are only evaluated on creation of the entry. Formula fields are evaluated on every save. Anyway, the expression to use is below.

(([entry.enddate]-[entry.startdate])/86400000) + 1