date ranges within date ranges

[JamesFlowers]

I have a range of dates in a database with {startdate} - {enddate} and I want to find out any of the intervening dates within this range within greater date range that is passed by a CR eg 10/7/2004 - 12/12/2004.

Is this possible?

TIA

James


James Flowers
Crystal Consultant

 

[synapsevampire]

Try:

If {table.startdate} >= minimum({?MyDateRangeParm}
and
{table.enddate} <= maximum({?MyDateRangeParm} then
"yep"
else
"nope"

Generally supplying:

Crystal version
Database used
Example data
Expected output

conveys requirements best.

-k