Selection between two date ranges

[bernie321]

Hi

We have a report that we need to restrict selection by Two date parameter values: FromDate and ToDate.

The database fields include a startdate and duration (in days).

How can I ensure that all records are selected including when the startdate is before the FromDate and the startdate + duration is after the ToDate.

Thanks

B

 

[kskid]

Try this


{Table.date} in
minimum([{?FromDate},{Table.StartDate}]) to
maximum([{?ToDate},({Table.StartDate}+{Table.Duration})])

Enclose in Parenthesis if in Record selection

(
{Table.date} in
minimum([{?FromDate},{Table.StartDate}]) to
maximum([{?ToDate},({Table.StartDate}+{Table.Duration})])
) and
blah blah blah

Cheers,
-LW

 

[lbass]

Assuming you want to show records that are active at any time during the parameter range, try:

dateadd("d",{table.duration},{table.startdate}) >= {?FromDate} and
{table.startdate} <= {?ToDate}

-LB