Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by David McKinney Linking to the Previous Row RE: Linking to the Previous Row

  • March 13, 2008 at 6:36 am

    #788981

    For this date range technique, for the end date:

    nextrow.PriceStartDate AS EndDate

    I usually do:

    dateadd(day, -1, nextrow.PriceStartDate) AS EndDate

    Also truncate to midnight the start/end date and any date comparisons to the range