Forum Discussion
Calculating the number of days within a 12-month period
Hi Sergei,
The only reason I calculated the June 8-9, 2017 trip as one day is because I already included June 8 in the trip prior (May 29 - June 8, 2017). There were a few trips where it overlapped. I separated them just because they went to a different city but maybe that just confuses things and I should just put the start of when they left Ontario and then when they returned. i can adjust for that to make things easier.
In regards to the second part, that is exactly where I get confused as well. It just states that you can be away for 212 days outside Ontario in a 12-month period. So do I just account for the start of november 2017 to end of october 2018 or do I start from the actual date (eg. Nov 10, 2017 to Nov 10, 2018). This is my confusion, on top of figuring out a formula lol.
Thanks again so much for your time and help!
I see Judie, thank you. Thus for the first part we may check if last day of the previous trip is the same as first date of next one and make the correction.
As for the second part I'm not familiar with OHIP rules, not sure what's the logic shall be here. Some insurances work if the person is within the limit before trip starts, some work from day to day. I'd try to modify the formula, but business rule is on your site.
Hi Sergei,
so I was able to clarify with Service Ontario that it's day to day. Will I have to modify the formula you came up with? I only ask instead of trying to figure it out myself, cuz your formula is heavy duty lol
Judie, I'll modify the formula
Leaving work Sergei, so I will look out for your response on Tuesday. Thanks so much, you are amazing and have a great long weekend!