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" 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