Newbie Questions

Re: Filter by Date

santhoshp — Mon, 25 Aug 2008 07:02:25 GMT

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.

Re: Filter by Date

dkenne — Thu, 14 Aug 2008 20:29:19 GMT

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.

Re: Filter by Date

Clay Fox — Thu, 14 Aug 2008 06:16:29 GMT

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.

Filter by Date

dkenne — Wed, 13 Aug 2008 15:26:38 GMT

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.