formula using between operator in a date range

[guymachine]

Hi,

I'm trying to add a date range filter to my report using the 'between' operator in the forumula section:

{Incident.Close Date & Time} between {?Fdate} and {?FTDate}

The two dates will come from the 2 parameters and i want the report to filter only between those two dates. Is there something wrong with the way i am using 'between'. I get the following error message:

"The remaining text does not appear to be part of the formula."

thanks,

Guy

 

[mbarron]

To use a "between" you need to use "In"

{Incident.Close Date & Time} in {?Fdate} and {?FTDate}


Mike

 

[kskid]

One other change to Mike's formula. It's to, not and

{Incident.Close Date & Time} in {?Fdate} to {?FTDate}