[DUG] another set of eyes

[Jeremy Coulter]

Yeah  its all good. I figured it out. Hell of a load off my mind I can tell
you !!  J

 

Jeremy

 

From: delphi-bounces at delphi.org.nz [mailto:delphi-bounces at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20100131/d69f841b/attachment.html