InfoPath Dev

Thank you for your reply.  I was looking at your form and realized I did not provide enough details. The repeating table contains fields from a calendar so the EventDate fields are DateTime.  If I was able to use only Date fields it would be fantastic.  But I cannot. I am using something very similar to this but I am not ...

Sounds possible using different views of a form for the input and different views of a list that can be exported to Excel.

 I have three controls on my form.  StartDate <date field> EndDate <date field> Repeating Table   The repeating table has a rule/condition on it to hide rows that do not meet a certain criteria (StartDate).  If I manually change the StartDate the repeating table is updated.  If I have a form load rule set ...