InfoPath - Find the minimum date in a repeating table
I had an InfoPath form, where I needed to copy the earliest date that appeared in a repeating table to a separate Date Field in the main data source. With the assistance of the following article, I was able to add a hidden column to the table with a formula that converts the separate date components into a numeric value that can be used in Math functions. The default value of the date field separate to the repeating table was then set to the value in the repeating date field where the value in the corresponding hidden field is the lowest of the current rows in the table.
The expression for the default value will be something like the following:
my:select_field_XPath[hidden_field_Xpath = xdMath:Min(hidden_field_Xpath)]
See http://www.bizsupportonline.net/infopath2007/select-minimum-date-infopath-repeating-table.htm for details.
Submit a review:
Login required.