{table.datefield}>={@fromDate} and {table.datefield} <= {@toDate}

 

or

 

{table.datefield} in {@fromDate} to {@toDate}  // look for 'in' in CR help

 

either of these will return TRUE for dates you want and FALSE for ones you don't, which is exactly what the criteria formula is expecting, true to keep and false to discard.

 

HTH

 

I forget the ? or @ as I rarely have to type them, just select the correct item from the list.

 

I think that this is because Commands were designed to retrieve data for parameter selection(it's only a theory as to their reason, but it seems to fit)...but since they are taking parameters to gather the data, they get confused and constantly ask for input.

 

What you could do is not use the parameters in the Command and instead add filters to the subreports based on the parameters.  Then you can link the subreport parameter to the main report parameter and only be prompted once per run instead of more times.