Formula for date range from fields in two tables (Crystal Reports) -

i trying create formula allow pull records fields in 2 different tables , print date in report.

1.) have report beginning , ending date parameters.

2.) have 2 formulas {@mindate} , {@maxdate} print minimum , maximum dates:

minimum{?event date}  maximum{?event date} 

i think i’m @ point.

3.) trying create formula allow pull records fields in 2 different tables , print date in report.

the closest have come is:

({event.date}>= {@mindate} and{event.date}<= {@maxdate})or ({calendar.date}>= {@mindate} and{calendar.date}<= {@maxdate})

this formula giving me boolean response, , think understand why giving me boolean response, don’t know instead. looking report show dates within original parameters.

i’m beginner @ crystal reports; sorry if novice question.

what have looks fine, need apply comparison logic in record selection formula instead of in regular formula. might suggest create 2 separate date parameters instead of using 1 has multi-select or ranges.

to record selection formula, click "report" in toolbar → "selection formulas" → "record". there enter logic:

({event.date} >= {@mindate} , {event.date} <= {@maxdate}) or ({calendar.date} >= {@mindate} , {calendar.date} <= {@maxdate}) 

alternatively, if go 2 separate parameters, can away min/max formulas:

{event.date} in {?start date} {?end date} or {calendar.date} in {?start date} {?end date}