AlexTeslin
Registered User.
- Local time
- Today, 01:58
- Joined
- Jul 10, 2008
- Messages
- 55
Hi,
I am trying to filter those records whith overlap times only. For example:
field1 TimeStart TimeFinish
rec1 13:00 15:00
rec2 14:00 14:30
rec3 15:00 16:00
rec4 14:30 15:00
This should output rec1, rec2 and rec4. But not rec3, because no other records overlap from 15:00 to 16:00. I can check distinguish between them if they would start at the same time, for example, but that is not enough.
Any suggestions would be greatly appreciated,
thank you
I am trying to filter those records whith overlap times only. For example:
field1 TimeStart TimeFinish
rec1 13:00 15:00
rec2 14:00 14:30
rec3 15:00 16:00
rec4 14:30 15:00
This should output rec1, rec2 and rec4. But not rec3, because no other records overlap from 15:00 to 16:00. I can check distinguish between them if they would start at the same time, for example, but that is not enough.
Any suggestions would be greatly appreciated,
thank you