I have a report on organizations. It has several tables that select records to display based on a date that I enter as "user input." The selection criteria for each of the date fields is the "specific date" <$userInput.startDate$>. This works great on most of my tables of data.

I am now trying to add a table of form data. I can successfully select forms on certain date fields by "hard coding" the dates in the fields in the report layout. For example, I can enter 4/24/07 into a date field in a form, then select that form by telling the report layout to set data on the table using the selection criterion "specific date" = 4/24/07. However, the data selector will not allow me to enter <$userInput.startDate$> as a criterion for "specific date" if the date comes from a form in the same way that it will allow it from the regular database. If I enter <$userInput.startDate$> into the date field and leave the field the program reverts to the current date.

This doesn't make sense to me because I'm assuming that entering a date prior to "run" is providing that date as a variable whenever it is requested. In this case (selecting on form data) the program won't even let me request it.

Can anyone help? Thanks!

Bob