This content has been marked as final. Show 3 replies
IF testdate BETWEEN first_date AND last_date THEN
If not then consider providing sufficient information for someone to help you.
1. Actual version number to three+ decimal places.
2. An example of what "is" an overlap
3. An example of something that "is not" an overlap
Is there any OVERLAP function in oracle to check date overlap checking?There is undocumented [url http://forums.oracle.com/forums/thread.jspa?messageID=1724277#1724277]OVERLAPS condition.
But better use
start1 < end2 and start2 < end1