Home Forums SQL Server 2005 T-SQL (SS2K5) finding gaps between termination date and next enrollment date and filter by gap >= 45 days for year 2013 RE: finding gaps between termination date and next enrollment date and filter by gap >= 45 days for year 2013

  • July 12, 2014 at 8:45 pm

    #1728971

    Tammy-274861 (7/12/2014)

    Hi Lynn!

    That is a good question. I was assuming that if the enrollment date is for instance 2/1/2013, that's when the enrollment starts and if termination date is on 12/31/2013, that day is still counted as being enrolled, but I'm not sure if it's actually so. I would say yes, so then We have to add 1 day, correct?

    I will have to confirm on Monday.

    Sorry for not having a definitive answer:(

    I will review the explanation of your code, I really appreciate you tsking the time to help me!!!

    I hsve found you and autoexcrement to be so helpful!!!

    Thank you so much!!! 😀

    Tammy

    Well, I am going with my experience with insurance and say the termination date is the last day of coverage.

    Did you also read my explanation regarding the ID you said was 46 and was actually 45 when you look at the dates knowing (or assuming) what are dates of coverage and what aren't.