Yeah its all good. I figured it out. Hell of a load off my mind I can tell you !! J
Jeremy From: delphi-boun...@delphi.org.nz [mailto:delphi-boun...@delphi.org.nz] On Behalf Of Nicholas Barrett Sent: Sunday, 31 January 2010 18:33 To: delphi Subject: Re: [DUG] another set of eyes 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
