Dates to Date Time interval

[Douglas Stransky]

I am trying to add a week to a date time interval.  

Fields are:  

Dates:  DateTime interval  --  The user enters in Dates field.  

d1:  Date Field

d2:  Date Field

NewDates:  DateTime Interval.

Form rules for 

d1=([entry.Dates.startDate.timestamp] + 604800000)    //+ 1 week -- This works fine //

d2=[entry.Dates.endDate.timestamp] = 604800000       //+ 1 week  -- This works fine//

NewDate=[entry.d1.timestamp]-[entry.d2.timestamp]    // d1 & d2 to a D-T interval

                                                                                   interval field -- this is Not working! //

It does not seem to be working at all.  Am I missing something to take d1 and d2 to make a new datetime interval field?   

Thanks!

Doug

[Alex Medved _ConfiForms_]

Hi @Douglas Stransky 

Little video to show how this can be done

Basically could have a rule to set it directly from the original Dates field (datetime interval)

NewDates=[entry.Dates.startDate.timestamp.add(604800000)]-[entry.Dates.endDate.timestamp.add(604800000)] 

Hope it helps

Alex