Re: Repeating table with date fields issues

Mel Clemente — Sun, 30 Dec 2012 07:24:13 GMT

Have you tried using the current() function, so if DisposalDate is less than current()/AcquisitionDate...

Repeating table with date fields issues

jiangshouying — Thu, 04 Oct 2012 11:33:27 GMT

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.

General

Re: Repeating table with date fields issues

Repeating table with date fields issues