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.