Hi,
I downloaded the MinDate.xsn file from http://www.infopathdev.com/forums/p/19066/66217.aspx#66217 (it contains a formula to calculate the Minimum date in a repeating table)
The formula is: my:group1/my:group2[translate(my:field1, "-T:", "") = xdMath:Min(xdMath:Eval(/descendant-or-self::node()/my:field1[. != ""], 'translate(., "-T:", "")'))]/my:field1
I created a text field (field4) and copied the XPath formula (above) into field4 as a "Default Value" and prefixed it with ../
Field4 Default Value: ../my:group1/my:group2[translate(my:field1, "-T:", "") = xdMath:Min(xdMath:Eval(/descendant-or-self::node()/my:field1[. != ""], 'translate(., "-T:", "")'))]/my:field1
This seems to work, but when I open the Rule Inspector, it says "Processing error" and won't display my formula under the "Calculated Default Values" heading.
Is there something wrong with the formula? Can it be written in a different way so that it will still display in the Rule Inspector?
Thanks