Post reply

finding gaps between termination date and next enrollment date and filter by gap >= 45 days for year 2013

  • July 14, 2014 at 6:57 am

    #1729121

    Good morning, Lynn!!! 😀

    I'm happy to say it works like a charm!!!!

    Your explanation is also really useful so I can understand what is going on.

    I have a final question, what are you using the dayslapsed for?

    I see it's the different between numdays and daysinyear, but is it being used or is this an extra check?

    Thanks a lot for all your help with my issue!!!

    Tammy

  • July 14, 2014 at 7:52 am

    #1729138

    Not really using it. Most of the columns returned by me are just for FYI. You should adjust the code as needed for your application.

  • July 14, 2014 at 7:56 am

    #1729139

    Lynn,

    Thank you so much for all your help!

    I will mark your last query as the solution to my problem!!! :w00t:

    I really appreciate all your time invested in helping me and your quick responses.

    Take care of yourself there!!!!

    Tammy

Viewing 3 posts - 46 through 47 (of 47 total)

You must be logged in to reply to this topic. Login to reply