Output date difference

Hello everyone!
I have two fields called ā€œstartdateā€ and ā€œenddateā€. The type is Date and time with a custom format of DD/MM/YYYY and Value Type Date.
Is it possible to output in a field the date difference between the two?
I tried startdate - enddate, record.values.startdate - record.values.enddate but canā€™t seem to wrap my head around it.
Also tried out = (record.values.startdate) - (record.values.enddate) and out = sub(startdate, enddate) but to no avail.

Where do you want to output this?

I suggest using a Number field, with field value expression.

End and Start are the datetime fields.

1 Like

Found it! sub(enddate, startdate)/86400000
Thank you very much for showing me the right direction!

1 Like