I have 4 date fields in a repeating table named Acquisition Date, Acquisition Input Date, Disposal Date and Disposal Input Date.
Now I need to apply some rules on the date:
1. Acquisition Date and Acquisition Input Date is mandatory fields - Set in controls properties - Done
2. Acquisition Input Date should greater than or equal to Acquisition Date - Create an Action rule, if not match, switch to a view - Done
3. If Disposal Date is not blank, Disposal Date should greater than Acquisition Date
4. Disposal Date should less than or equal to Disposal Input Date
Example:
Repeating Table Line 1:
Acquisition Date:02/10/2012
Acquisition Input Date: 03/10/2012
Disposal Date:(blank)
Disposal Input Date: (blank)
Repeating Table Line 2:
Acquisition Date:29/09/2012
Acquisition Input Date: 30/09/2012
Disposal Date:01/10/2012
Disposal Input Date: 03/10/2012
For the example showed above, this should pass the rules, but InfoPath will check all Disposal Dates and all Acquisition Dates, Disposal Date (Line 2) is less than Acquisition Date (Line 1), and form will show error message.
My question is how can I let form template to check date in the same line, no need to check all dates.
Hope you guys can give me some advise, thanks.