Hi Geoff,

thanks for sticking with me.

do you see any logical difference between your where clause and mine:

>	WHERE NOT EMPTY(dDate) AND ;
>	      IIF(YEAR(m.tdStart)=YEAR(m.tdEnd),;
>		      BETWEEN(DATE(YEAR(m.tdStart), MONTH(dDate), DAY(dDate)), m.tdstart, m.tdend),;
>		      (DATE(YEAR(m.tdStart), MONTH(dDate), DAY(dDate)) >=m.tdstart OR ;
>		       DATE(YEAR(m.tdEnd), MONTH(dDate), DAY(dDate)) <=m.tdend));

	WHERE NOT EMPTY(dDate) ;
		AND (BETWEEN(DATE(YEAR(m.tdStart), MONTH(dDate), DAY(dDate)) , m.tdstart, m.tdend) ;
			OR BETWEEN(DATE(YEAR(m.tdEnd), MONTH(dDate), DAY(dDate)) , m.tdstart, m.tdend));

They both appear to give the same answer and I think mine is a bit more readable, but want to make sure there is no subtle difference.

Thanks again.