Re: How to add number of days to a date from a SharePoint List

Potemkine — Wed, 09 Feb 2011 21:21:04 GMT

Hi, I think you need to write some code to do that on InfoPath 2003. The add Day function is include since Infopath 2007.

How to add number of days to a date from a SharePoint List

Jenny18 — Wed, 09 Feb 2011 14:25:39 GMT

Hi, I am using InfoPath 2003 and have a situation to which I need some help. I am trying to set up a form and one of the fields is a date calculation.

I have a DatePicker control that displays the current date.

I have 2 two other fields.

1 is a Subject field that is a dropdown that uses a data connection to a SharePoint list that looks like the following:

Subject     Days
Samples     14
Standards    7
Labels         7
Projects      356

I would like to create another field called EstimatedCompletionDate which depending on which Subject is selected, will add the number of days to the DateInitiated field.

Does anyone have a solution for how to do this? In desparate need of some help!

Thank you!

SharePoint Integration

Re: How to add number of days to a date from a SharePoint List

How to add number of days to a date from a SharePoint List