Dates to Date Time interval

Question

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_ · Answer

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

Douglas Stransky · Answer

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_ · Answer

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