InfoPath Dev

Hello Jorge,  That's not much information to go on.  Could you try walking the code in the debugger to find at least which is the line where the error is occurring?

Well, this seems to be a pretty reliable formula for counting the total number leaf nodes (fields) in a form, assuming you don't have any childless groups in your data source:    count((//*[not(*)] | //@*)[not(name() = "xml:lang")]) And then this would count all the fields that have been filled in:    ...

Well, the qRules FormatDate command should be able to accomplish that for you, without all this fancy XPath.

This should work for that: concat(substring(field1, 6, 2), "/", substring(field1, 9, 2), "/", substring(field1, 1, 4), " ", substring("0", 1, substring(field2, 1, 2) mod 12 + 12 * (substring(field2, 1, 2) mod 12 = 0) < 10), substring(field2, 1, 2) mod 12 + 12 * (substring(field2, 1, 2) mod 12 = 0), ...

Please try this instead of RateExpiration.SetValue(string.Empty);                 if (RateExpiration.MoveToFirstChild())                 ...

You said you're using a default value formula to have some textbox values match the values of other fields.  You can do the same thing with these checkbox fields; you just need to do it in the fields' property dialog rather than the checkbox controls' property dialog.

Well, this is the formula I came up with based on your original question: concat(substring(field1, 6, 2), "/", substring(field1, 9, 2), "/", substring(field1, 1, 4), " ", substring("0", 1, substring(field2, 1, 2) mod 12 + 12 * (substring(field2, 1, 2) mod 12 = 0) < 10), substring(field2, 1, 2) mod 12 + ...

Please try modifying the field's properties instead of the control's properties.

I suggest using two fields for the auto numbering - one that's not displayed and just uses that formula you have to contain the raw integer value (1,2,3), and a second one that has the prefix and zero-padding. Then for the second field, you could use this formula. concat('BR', substring('00', 1, 3 - string-length(RowNum)), ...

Why not just have the default value as now(), and use the formatting options to display it the way you want it?