https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/123906.aspxMon, 22 Feb 2021 16:59:00 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123906Wondra0https://www.infopathdev.com:443/forums/thread/123906.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123906It 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.https://www.infopathdev.com:443/forums/thread/123879.aspxFri, 12 Feb 2021 17:31:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123879Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123879.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123879I'm having a hard time understanding your question. Here's a sample form with some rules that hopefully will serve as an example. Save the attached file locally, right click and select Design to open in design mode. Then you can preview and look at the rules. If you need help with your form, feel free to attach under the Options tab in a reply.https://www.infopathdev.com:443/forums/thread/123876.aspxThu, 11 Feb 2021 16:27:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123876Wondra0https://www.infopathdev.com:443/forums/thread/123876.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=123876I 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" column and the "Test Date -7 Days" to show the calculation date in those columns. I am adding the addDays function, see below: addDays(PartOnSiteDate, -14 = TestDateless14days) my result is that when I add a date to the PartOnSiteDate, the same date as the PartOnSiteDate populates in the "TestDateless14days" calculated column. What need to happen is that I get a date that would be minus 14 days of the "PartOnSiteDate" to populated in the TestDateless14days" calculated column. Please advise. Thank you