[DUG] another set of eyes

[Nicholas Barrett]

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/1836f653/attachment.html