Hi Jeremy, That where clause should work. If START_FIELD = 2010.01.31 and END_FIELD = 2010.03.14 and START_RANGE = 2010.02.22 and END_RANGE = 2010.02.26 then you'll find that
WHERE (START_FIELD < END_RANGE) AND (END_FIELD > START_RANGE) with the values WHERE (2010.01.31 < 2010.02.26) AND (2010.03.12 > 2010.02.22) Hope that helps. Cheers, Nick Barrett
_______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe
