Stuart McLachlan
stuart at lexacorp.com.pg
Mon Jul 12 19:11:35 CDT 2004
On 12 Jul 2004 at 13:22, DJK(John) Robinson wrote: > Not enough, sorry, Doris. > > Paul, what you need is this: > > start date between DateFrom and DateTo > OR finish date between DateFrom and DateTo > OR (start date before DateFrom AND finish date after DateTo) > Why not just StartDate <= DateTo and FinishDate >= DateFrom -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.