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