InfoPath Dev

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.

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.