Results 1 to 2 of 2

Thread: Comparing Date Spans

  1. #1
    Join Date
    Nov 2008
    Posts
    1

    Comparing Date Spans

    I need to write a query that would compare 2 pairs of dates.A start and end date for both rows. The second start date needs to be >= to the first end date. That is, there should be no gaps between the second start date and first end date.

    ex: Good Scenario

    First Start: 10/01/2006 First End: 12/31/2007
    Second Start: 11/30/2007 Second End: 01/31/2008

    ex: Bad Scenario

    First Start: 10/01/2006 First End: 12/31/2007
    Second Start: 02/01/2008 Second End: 04/30/2008

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Can you post table schema?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •