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

[Douglas Stransky]

Thanks,

I got that to finally work using an IFTTT rule.

I have a second IFTTT to create a new entry with Date =[entry.NewDates]   (plus copies of the other fields).  The intent is to iterate new entries until the end date condition is met.  The condition is:  [entry.Dates.endDate]:>RecurEnd

The follow-up question I have is both IFTTTs will not fire upon creation of the new entry.   The First IFTTT has no condition on it whatever and both are set to fire 'OnCreated'.  

Based on the table view, the two IFTTTs only fire once.  

Title    Dates                                       NewDates                                  Recur End

Test1  Sep 3, 2025 - Sep 4, 2025        Sep 10, 2225 - Sep 11, 2025      Oct 1, 2025  

Test1  Sep10, 2025 - Sep 11 2025      Sep 10, 2225 - Sep 11, 2025      Oct 1, 2025

The intent is to fire until Dates.endDate :> 1 OCT ... ie.e 17 & 24 Sep entries should also appear in the table.  

How should I do this?

Thanks,
Doug

[Alex Medved _ConfiForms_]

Honestly, not sure what are you trying to do, but certainly something like this is not right [entry.Dates.endDate]:>RecurEnd

https://wiki.vertuna.com/spaces/CONFIFORMS/pages/1212436/ConfiForms+Filters

It should be the field name on the left and the value on the right of the expression

Alex