InfoPath Dev

I have created a repeating table and want to have it display appointments that are one day more than the date entered in the query filed by the user. Specifically, the user specifies a particular date to view appoints for that date and then a second table should display all appointments for the following day (+1) and a third table to display all appointments for 2 days later, etc.

I understand that date calculations can be complicated with InfoPath 2003 (which I am using). Any help is appreciated. Ideally, I want to display a week's worth of appointment based on the date chosen by the user.

Thanks.

With 2007 they have a date +1 function.

You would need to use datediff() vbscript. Do a search on datediff and you should find some samples.

Thanks, I found some good examples to use. However, now I am having trouble because I am trying to bind a non-repeating query to a repeating table. I don't understand the repeating/non-repeating properties of InfoPath. How can I make my query (or any other field or group) repeating? Currently, when I go to the properties box for the query the option to select the "repeating" check box is grayed-out and I can't change it. Why?

Thanks.

Hi Dkenne,

I think you are using secondary data source for query. For secondary data source all the options in properties window will be disabled.

The "repeating" check box option will be enabled for field or group which is in Main data source.