Calculate Recision Date

[BrailleSchool]

Hi all,

Long time, no see. I am not sure how to approach this specific task and would like your feedback on this. I have a Month Calendar on my form. The automatic date is set to the current date. What I need to accomplish is to calculate the rescission date. The date is always three days in the future from the current date (excluding the current date); however, the amount of days in the future never includes holidays or weekends, so if there are holidays and/or weekends, these days are skipped from the calculation.

As an example. if today is 11/16/2014 and there are no holidays or weekends, the rescission date would then be 11/19/2014. If Monday 11/17/2014 was a holiday, then the rescission date would be 11/18/2014, etc.

If I recall, you can check to see if the date is a weekend, BUT, can you check to see if the date is a holiday? Maybe I would need to store these dates in a database?

Any ideas as to go about this?

[.paul.]

some holiday dates aren't fixed and need to be calculated year by year

[wes4dbt]

If Monday 11/17/2014 was a holiday, then the rescission date would be 11/18/2014, etc.

If you don't count the holiday, then wouldn't the recission date be 11/20/2014? Or did I misunderstand?

[BrailleSchool]

If you don't count the holiday, then wouldn't the recission date be 11/20/2014? Or did I misunderstand?

If the holiday is within the three day range from the current date (current date excluded), then those federal holidays and/or weekends are eliminated, so then the date would be the next day after the holiday or weekend or both.

[wes4dbt]

If the holiday is within the three day range from the current date (current date excluded), then those federal holidays and/or weekends are eliminated, so then the date would be the next day after the holiday or weekend or both.

So instead of 3 business days, the rescission date is one business day. Sorry I don't have an answer but it's an interesting question. Good luck

[wes4dbt]

I got curious and did a little google to this link http://truthfullending.com/3-day-right-of-rescission/

Maybe your doing something completely different, but it has this example

Another Example
Now let’s say you sign your loan documents on Friday, but the following Monday is a federal holiday. Your rescission period begins the day after signing, which would be Saturday in this case. We skip Sunday, but we also skip Monday since it’s a federal holiday. So day 2 would be Tuesday, and day 3 would be Wednesday. You would have until Wednesday at midnight to rescind in this example.

[.paul.]

For help calculating holiday dates, have a look at my dropdown calendar control:

http://www.vbforums.com/showthread.p...lendar-control

[BrailleSchool]

I got curious and did a little google to this link http://truthfullending.com/3-day-right-of-rescission/

Maybe your doing something completely different, but it has this example

Yes, this is what I am needing to calculate and wonder what the best way would be. The date would display in a label beneath the Month View based on the current date on form load or a date specified by the user when they select/click on a date on the Month View.

[BrailleSchool]

For help calculating holiday dates, have a look at my dropdown calendar control:

http://www.vbforums.com/showthread.p...lendar-control

Will do, thanks.

[wes4dbt]

I found a couple of example of perpetual calenders (they are in C)
http://www.codeproject.com/Articles/...at-least-until
http://www.codeproject.com/Articles/...lendar-control

But as .paul said some holidays are on different days of the year. Seem like the holiday dates my need to be loaded with a yearly update function.

[wes4dbt]

Are you only interested in Federal Holidays? If so, I was able to find some example using Google.

[BrailleSchool]

Are you only interested in Federal Holidays? If so, I was able to find some example using Google.

Just U.S.A. holidays.
I am doing more research regarding this. Seems it won't be an easy task to implement in the Notary Signing Agent app I am writing.

[dbasnett]

For Holidays see:

Holidays