Re: How do I simulate the addDays function in InfoPath 2003?

Julie Anderson — Wed, 25 Feb 2009 21:44:24 GMT

I found my solution, but am getting one minor validation error. I used the information in the post below to create a Sharepoint list with the dates I needed.

http://www.bizsupportonline.net/infopath2003/autofill-fields-infopath-dropdown-selection-secondary-data-source.htm

The error I'm getting though is the red dashed border indicating invalid values when I select from my drop down list. I'm using dates and I submit to an Access Database, so my first thougt was that the formatting was not compatible between all of the data fields. I worked with that for a while and eventually just changed them all to text fields but am still getting the errors.

Please let me know if you have an idea for me.

How do I simulate the addDays function in InfoPath 2003?

Julie Anderson — Wed, 25 Feb 2009 19:43:37 GMT

I've read several posts regarding calculating dates and can't seem to find the answer. I've tried several options using rules and can't make it work. I have a Date Picker field, ExpenseReportDate, that the user will select.

Based on that date I want the weekdays for the two weeks prior to that to automatically populate (the date they choose will be the last day in that period).

i.e.

ExpenseReportDate = 2/15/2009

Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun

2/2 2/3 2/4 2/5 2/6 2/7 2/8 2/9 2/10 2/11 2/12 2/13 2/14 2/15

Any help would be appreciated.

Controls

Re: How do I simulate the addDays function in InfoPath 2003?

How do I simulate the addDays function in InfoPath 2003?