"Bruno Grampa" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 5:34 AM
Subject: Date interval problem
Hello,
i have a table with two dates, that define an interval.
In the query i have two more dates, and i want to select all the records
that overlap
Michael Thygs writes:
> Hello Bruno,
>
> its a little bit complicated. You have to put a little bit of brain in it!
>
> The situation you ask for is:
>
> tab2.interval <>
> possible intervals of table 1, which should be displayed are:
> 1. <--->
>
m <=
tab2.date_to)
AFAIK, this should result in all overlapping date ranges being selected.
> -Original Message-
> From: Michael Thygs [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 05, 2001 1:29 PM
> To: [EMAIL PROTECTED]
> Subject: AW: Date interval problem
>
&g
icht-
Von: Bruno Grampa [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 5. Oktober 2001 12:34
An: [EMAIL PROTECTED]
Betreff: Date interval problem
Hello,
i have a table with two dates, that define an interval.
In the query i have two more dates, and i want to select all the records
that overlap t
Hello,
i have a table with two dates, that define an interval.
In the query i have two more dates, and i want to select all the records
that overlap that period.
Any hint to solve this problem?
Thanks,
Bruno
-
Before posting,
