Set endDate in DateTime Interval

[Markisio]

Hi there

I thought this is easy :) I have a form with these fields

lengthDays --> Numeric 

durationDate --> DateTime Interval 

a rule to perform the following

durationDate.endDate=([entry.durationDate.startDate.add(86400000*[entry.lengthDays])])

however for some reason the endDate of durationDate doesn't get populated, not sure why. I am sure its something silly, it works if I change the duration date into 2 fields ( start and end date) 

am I loosing it :) please help, thanks 

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Markisio 

This is one field with start and end dates and expects the value format as this: startDateTimestamp-endDateTimestamp, so you do this as follows

durationDate=[entry.durationDate.startDate]-[entry.durationDate.startDate.add(86400000*[entry.lengthDays])]

Alex