InfoPath Dev

 its a time stamp that I am adding to a note that is created in a text box.   I was hoping that there was a way to format it using xpath. 

How can I modify the following in InfoPath substring-after(now(), "T") so that it displays the time as 1:00 PM instead of 13:00:00?  

Sorry see it now, you use my field accounting date and change the formula. now it does show correctly in the email subject. Thanks you have be so very helpful!!!

I put in this formula concat(Name[Number = substring(Journal Date, 6, 2)], " ", substring(Journal Date, 1, 4)) and when I try to verify it, I get this error. "xdXDocument:GetDOM("month")/Months/Month/Name/dfs:dataFields/my:SharePointListItem_RW/my:Date" does not point to a valid location path of a field or ...

I have attached the form. Thanks.

so I substituted field 1 with Journal Date since that's the name of my field with where the date picker holds data. what do I use for Name[Number? what do the 6,2 and 1,4 represent in your formula? concat(Name[Number = substring(Journal Date, 6, 2)], " ", substring(Journal Date, 1, 4))

Got the eval to work except that I want "&" instead of | | and I only need the & between the 2 not after  here is the formula I have so far without any date  concat("LEASE JE_", JobDescription, "_", RegionContractGroup, "_Portfolio(s):", eval(eval(Value[. != ""], ...

 ok, thanks and so very much appreciated!

 ok the filter worked, except that I just grabs the 1st choice if there are two or more they do not show. is that an easy fix? for the accounting date . In the form I am using a date picker, but I need the date to show as MMMM YYYY, because the day of the month chosen isn't relevant and we don't want it shown on the list or ...

Hi, Thanks for responding.   The fields are on the form and populating.   I attached the form.   Tony