>*dob = birthdate, dstart = initial date, dend = final date > >SELECT * FROM clients ; > WHERE MONTH(clients.dob) >= MONTH(dstart) AND ; > MONTH(clients.dob) <= MONTH(dend) AND ; > DAY(clients.dob) >= DAY(dstart) AND ; > DAY(clients.dob) <= DAY(dend) >Gonz,
SELECT * FROM clients; WHERE DateRange(clients.dob, dstart, dend) FUNCTION DateRange * VFP 6.0 required LPARAMETERS tDOB, tdStart, tdStop LOCAL llresult, lnmonth, lnday, ldthisdate lnmonth = MONTH(tDOB) lnday = DAY(tDOB ldthisdate = DATE(YEAR(DATE()), lnmonth, lnday) llresult = BETWEEN(ldthisdate, tdStart, tdStop) RETURN llresult ENDFUNCI'm not sure if this can even be done without the UDF. 'Course, haven't really given it a lot of thought.< g >