Qrules date diff in repeating table. - InfoPath Dev
in

InfoPath Dev

Qrules date diff in repeating table.

Last post 12-15-2011 07:50 AM by shniggens. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 12-14-2011 01:11 PM

    Qrules date diff in repeating table.

    I have a repeating table that contains both start and end dates as columns.  I use Qrules Datediff to calculate the difference between these two dates, and output to the Result node. 

    This works fine for the first row, but how do I make it do it to all repeating rows?

  • 12-14-2011 07:44 PM In reply to

    Re: Qrules date diff in repeating table.

    I suggest adding a rule to both the StartDate and EndDate fields that invokes the DateDiff command any time one of them changes, and then sets the value of the Result node to another field within the repeating table.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 12-15-2011 06:23 AM In reply to

    Re: Qrules date diff in repeating table.

    That's pretty much how I have it set up.  But it only sets the first row. 

  • 12-15-2011 06:29 AM In reply to

    Re: Qrules date diff in repeating table.

    Could you send your template to the Qdabra support alias?

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 12-15-2011 07:50 AM In reply to

    Re: Qrules date diff in repeating table.

    Thanks Jimmy.  I didn't have both date fields set to run the calc.  When I set them both to do it, it works on all rows. 

     

Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.