InfoPath Dev

It worked!!!! Thank you so much, I am so appreciative for your help. I have been trying to get this formula for weeks. You are a life saver.

How can I get my columns from infopath to stay in SharePoint after i have published the form to SharePoint? Each time i edit the form in infopath, i have to add the columns each time, under form options "Property Promotion" before publishing to SP. Thank you!

I have created an infopath form and am not able to get the calculation to work properly. My scenario is that I have 2 travel dates and 2 test dates in my form ( a date for each travel date). How I want this to work is, that when the user selects the "Onsite Date", i want the test date to populate in the "Test Date -14 days" ...

 Hello,  I have a sharepoint list that I am referencing in my InfoPath form. I created a data connection in the InfoPath form. I have 2 list, an Activity type list and an Type of activity list. When you select the type of activity type, and they select the type of activity the options are filtered and ...