Re: Help needed using DateDiff Function multiple times on a single form

Hilary Stoupa — Fri, 20 Jan 2012 20:34:15 GMT

In your rule where you run the date diff function, copy the value of the results node to another field. Then you can run additional commands without worrying about it gettng overwritten.

Help needed using DateDiff Function multiple times on a single form

Durbs — Fri, 20 Jan 2012 20:22:54 GMT

I have a form that has 3 from dates and 3 To dates.

I have injected the form with QRules and I am using the DateDiff function triggered by a rule on when users enter the To Field to return the amount of days between the Start and End date.
The result of the query returns to the QRules 'Result' field which I have put on my form.
Example Start Date 20-01-12 End Date 22-01-12 Results = 2
Code: concat("DateDiff /date1=", ., " /date2=", startdate, " /component=days")

Now on the same form I have another field (Not a repeatintg Table)
Trip 2 Start Date (From2) Trip 2 End Date (To2)
Again I use the Date Diff Function obviously this time referenceing the 2nd Start and End Date Fields
Code: concat("DateDif / date1=", ., "/date2=", From2, "/component=days")
The issue is (And I'm sure its just me not quite understanding how this works) How can I get the query to return the value for the second date to anything other than the QRules 'Result' Field and if I can't do that how do I get the second dates to return another value to the field other than '2' the value from the first query.

Hope I explained that well enough.

Appreciate any responses.

Qdabra qRules

Re: Help needed using DateDiff Function multiple times on a single form

Help needed using DateDiff Function multiple times on a single form