Mar 05 2022 07:22 PM
I am trying to figure out how or what formula to convert thousands of enrollees from a 30 day coverage period to a calendar month triggered by payment and ensuring no gap in coverage.
Here is an example:
A member whose payment processed 3/5/22, their coverage period would be 3/6/22 thru 4/5/22
I need it to be payment on 3/5/22 coverage is 3/1/22 thru 3/31.
While that sounds "simple," here is another example
Payment 3/25/22 coverage period 3/26/22 thru 4/25/22
need it to be payment 3/25/22 coverage period 4/1/22 thru 4/30/22
keeping in mind that their previous coverage was payment 2/25/22 coverage 2/26/22 thru 3/24/22, of course, Feb. Being a short month is already an outlier.
Currently, payment dates are daily and open to adjusting to accomplish the desired result.
Mar 05 2022 09:50 PM
Mar 15 2022 11:11 AM