InfoPath Dev

Yes, this does work! Thank you. I tried the substring-after, already but did not think to nest two functions.

i don't have the ability to change my original datetype, due to the datasource, so this does not work for me, but thanks for your help.

Thanks for your response, unfortunately it does not work, as it is starting at beginning of string and I need to grab the last 4 digits (2013), so start at the end and move backward 4; and the date is a field populating during rendering.

Hi, I am looking for an expression I can use in xpath that works similar to the function 'Right', which starts at the far right of a string and then moves to the left a designated number of spaces. What I am trying to do is dispay just the year of a completion date. But substring(Date,6,4) did not work for me because the datetype is ...

I did get the expression to be accepted in the fx box, but now I am not getting correct breaking.  It breaks the 1st unit but nothing after that.  my formula boxes read 1 and 3, so the count portion is working correctly, but the preceding-sibling count is not.  Any suggestions? I am attaching an example of my file.  I would ...

Great, this works, I am thrilled.  Thank you for your time. Could you explain why using the full xpath did not work for the second reference (equipinsp = fail)?  It seems like using the full path would always work.

Thanks for the response.  If I put the expression in the Text Box Properties/Default Value box I get an error that the value is not valid for my data type (which is Whole Number since it is count expression). If I use the fx  box I get the error ""../../OptGroup_EQUIPMENT/EQUIPMENT/equipmenttype/EquipInsp" does not point ...

Thank you for your help, but I never did resolve this, and ended up changing form.  I now am faced with the same issue and this is maddening.  I tried your template again and I know it is something I am doing... If I just put the expression into - Text Box Properties/Default Value/Value field ...

Thanks. I agree having to write code was a pain.  I am in a similiar situation, with another form, so let me try to be clearer. I have a node (../../OptGroup_EQUIPMENT/EQUIPMENT) and under that is 2 child nodes (../../OptGroup_EQUIPMENT/EQUIPMENT/equipmenttype; ../../OptGroup_EQUIPMENT/EQUIPMENT/EquipInsp) each of the child node have ...

I was only able to attach one file to last message.  Here is the xml output.  I appreciate anyone who can help.