> 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.