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

  • Hi Lynn and autoexcrement!

    @autoexcrement, thank you so much for your time in helping me!!! 😀

    @Lynn, yes, I saw your explanation, and regarding the 46 days it does make sense what you are saying and that's what I will go by!

    So by changing the code to the last one you posted to account for leap year, that should make it work for any working year I use, correct?

    Thanks a lot for such quick replies!!!! :w00t:

    Tammy