Canadian Holidays up to 2020

I made a function in VB6 that calculates all the holidays until 2020, but I can't post the code in the CodeBank because I did it for work.... BUT, I can post the result :D (at least I assume I can....)

So... for anyone interested, here it is:

Code:

---

Year, Date, "Weekday Name","Holiday Name"
2008, 02/18/2008,Monday,"Family Day"
2008, 03/21/2008,Friday,"Good Friday"
2008, 03/24/2008,Monday,"Easter Monday"
2008, 05/19/2008,Monday,"Victoria Day"
2008, 07/01/2008,Tuesday,"Canada Day"
2008, 08/04/2008,Monday,"Civic Holiday"
2008, 09/01/2008,Monday,"Labour Day"
2008, 10/13/2008,Monday,"Thanksgiving Day"
2008, 11/11/2008,Tuesday,"Remembrance Day"
2008, 12/25/2008,Thursday,"Christmas"
2008, 12/26/2008,Friday,"Boxing Day"
2009, 01/01/2009,Thursday,"New Year's Day"
2009, 02/16/2009,Monday,"Family Day"
2009, 04/10/2009,Friday,"Good Friday"
2009, 04/13/2009,Monday,"Easter Monday"
2009, 05/18/2009,Monday,"Victoria Day"
2009, 07/01/2009,Wednesday,"Canada Day"
2009, 08/03/2009,Monday,"Civic Holiday"
2009, 09/07/2009,Monday,"Labour Day"
2009, 10/12/2009,Monday,"Thanksgiving Day"
2009, 11/11/2009,Wednesday,"Remembrance Day"
2009, 12/25/2009,Friday,"Christmas"
2009, 12/26/2009,Saturday,"Boxing Day"
2010, 01/01/2010,Friday,"New Year's Day"
2010, 02/15/2010,Monday,"Family Day"
2010, 04/02/2010,Friday,"Good Friday"
2010, 04/05/2010,Monday,"Easter Monday"
2010, 05/24/2010,Monday,"Victoria Day"
2010, 07/01/2010,Thursday,"Canada Day"
2010, 08/02/2010,Monday,"Civic Holiday"
2010, 09/06/2010,Monday,"Labour Day"
2010, 10/11/2010,Monday,"Thanksgiving Day"
2010, 11/11/2010,Thursday,"Remembrance Day"
2010, 12/25/2010,Saturday,"Christmas"
2010, 12/26/2010,Sunday,"Boxing Day"
2011, 01/01/2011,Saturday,"New Year's Day"
2011, 02/21/2011,Monday,"Family Day"
2011, 04/22/2011,Friday,"Good Friday"
2011, 04/25/2011,Monday,"Easter Monday"
2011, 05/23/2011,Monday,"Victoria Day"
2011, 07/01/2011,Friday,"Canada Day"
2011, 08/01/2011,Monday,"Civic Holiday"
2011, 09/05/2011,Monday,"Labour Day"
2011, 10/10/2011,Monday,"Thanksgiving Day"
2011, 11/11/2011,Friday,"Remembrance Day"
2011, 12/25/2011,Sunday,"Christmas"
2011, 12/26/2011,Monday,"Boxing Day"
2012, 01/01/2012,Sunday,"New Year's Day"
2012, 02/20/2012,Monday,"Family Day"
2012, 04/06/2012,Friday,"Good Friday"
2012, 04/09/2012,Monday,"Easter Monday"
2012, 05/21/2012,Monday,"Victoria Day"
2012, 07/01/2012,Sunday,"Canada Day"
2012, 08/06/2012,Monday,"Civic Holiday"
2012, 09/03/2012,Monday,"Labour Day"
2012, 10/08/2012,Monday,"Thanksgiving Day"
2012, 11/11/2012,Sunday,"Remembrance Day"
2012, 12/25/2012,Tuesday,"Christmas"
2012, 12/26/2012,Wednesday,"Boxing Day"
2013, 01/01/2013,Tuesday,"New Year's Day"
2013, 02/18/2013,Monday,"Family Day"
2013, 03/29/2013,Friday,"Good Friday"
2013, 04/01/2013,Monday,"Easter Monday"
2013, 05/20/2013,Monday,"Victoria Day"
2013, 07/01/2013,Monday,"Canada Day"
2013, 08/05/2013,Monday,"Civic Holiday"
2013, 09/02/2013,Monday,"Labour Day"
2013, 10/14/2013,Monday,"Thanksgiving Day"
2013, 11/11/2013,Monday,"Remembrance Day"
2013, 12/25/2013,Wednesday,"Christmas"
2013, 12/26/2013,Thursday,"Boxing Day"
2014, 01/01/2014,Wednesday,"New Year's Day"
2014, 02/17/2014,Monday,"Family Day"
2014, 04/18/2014,Friday,"Good Friday"
2014, 04/21/2014,Monday,"Easter Monday"
2014, 05/19/2014,Monday,"Victoria Day"
2014, 07/01/2014,Tuesday,"Canada Day"
2014, 08/04/2014,Monday,"Civic Holiday"
2014, 09/01/2014,Monday,"Labour Day"
2014, 10/13/2014,Monday,"Thanksgiving Day"
2014, 11/11/2014,Tuesday,"Remembrance Day"
2014, 12/25/2014,Thursday,"Christmas"
2014, 12/26/2014,Friday,"Boxing Day"
2015, 01/01/2015,Thursday,"New Year's Day"
2015, 02/16/2015,Monday,"Family Day"
2015, 04/03/2015,Friday,"Good Friday"
2015, 04/06/2015,Monday,"Easter Monday"
2015, 05/18/2015,Monday,"Victoria Day"
2015, 07/01/2015,Wednesday,"Canada Day"
2015, 08/03/2015,Monday,"Civic Holiday"
2015, 09/07/2015,Monday,"Labour Day"
2015, 10/12/2015,Monday,"Thanksgiving Day"
2015, 11/11/2015,Wednesday,"Remembrance Day"
2015, 12/25/2015,Friday,"Christmas"
2015, 12/26/2015,Saturday,"Boxing Day"
2016, 01/01/2016,Friday,"New Year's Day"
2016, 02/15/2016,Monday,"Family Day"
2016, 03/25/2016,Friday,"Good Friday"
2016, 03/28/2016,Monday,"Easter Monday"
2016, 05/23/2016,Monday,"Victoria Day"
2016, 07/01/2016,Friday,"Canada Day"
2016, 08/01/2016,Monday,"Civic Holiday"
2016, 09/05/2016,Monday,"Labour Day"
2016, 10/10/2016,Monday,"Thanksgiving Day"
2016, 11/11/2016,Friday,"Remembrance Day"
2016, 12/25/2016,Sunday,"Christmas"
2016, 12/26/2016,Monday,"Boxing Day"
2017, 01/01/2017,Sunday,"New Year's Day"
2017, 02/20/2017,Monday,"Family Day"
2017, 04/14/2017,Friday,"Good Friday"
2017, 04/17/2017,Monday,"Easter Monday"
2017, 05/22/2017,Monday,"Victoria Day"
2017, 07/01/2017,Saturday,"Canada Day"
2017, 08/07/2017,Monday,"Civic Holiday"
2017, 09/04/2017,Monday,"Labour Day"
2017, 10/09/2017,Monday,"Thanksgiving Day"
2017, 11/11/2017,Saturday,"Remembrance Day"
2017, 12/25/2017,Monday,"Christmas"
2017, 12/26/2017,Tuesday,"Boxing Day"
2018, 01/01/2018,Monday,"New Year's Day"
2018, 02/19/2018,Monday,"Family Day"
2018, 03/30/2018,Friday,"Good Friday"
2018, 04/02/2018,Monday,"Easter Monday"
2018, 05/21/2018,Monday,"Victoria Day"
2018, 07/01/2018,Sunday,"Canada Day"
2018, 08/06/2018,Monday,"Civic Holiday"
2018, 09/03/2018,Monday,"Labour Day"
2018, 10/08/2018,Monday,"Thanksgiving Day"
2018, 11/11/2018,Sunday,"Remembrance Day"
2018, 12/25/2018,Tuesday,"Christmas"
2018, 12/26/2018,Wednesday,"Boxing Day"
2019, 01/01/2019,Tuesday,"New Year's Day"
2019, 02/18/2019,Monday,"Family Day"
2019, 04/19/2019,Friday,"Good Friday"
2019, 04/22/2019,Monday,"Easter Monday"
2019, 05/20/2019,Monday,"Victoria Day"
2019, 07/01/2019,Monday,"Canada Day"
2019, 08/05/2019,Monday,"Civic Holiday"
2019, 09/02/2019,Monday,"Labour Day"
2019, 10/14/2019,Monday,"Thanksgiving Day"
2019, 11/11/2019,Monday,"Remembrance Day"
2019, 12/25/2019,Wednesday,"Christmas"
2019, 12/26/2019,Thursday,"Boxing Day"
2020, 01/01/2020,Wednesday,"New Year's Day"
2020, 02/17/2020,Monday,"Family Day"
2020, 04/10/2020,Friday,"Good Friday"
2020, 04/13/2020,Monday,"Easter Monday"
2020, 05/18/2020,Monday,"Victoria Day"
2020, 07/01/2020,Wednesday,"Canada Day"
2020, 08/03/2020,Monday,"Civic Holiday"
2020, 09/07/2020,Monday,"Labour Day"
2020, 10/12/2020,Monday,"Thanksgiving Day"
2020, 11/11/2020,Wednesday,"Remembrance Day"
2020, 12/25/2020,Friday,"Christmas"
2020, 12/26/2020,Saturday,"Boxing Day"

---

I hereby declare all other utterly useless programs obsolete. This is truely the most utterly useless program of the 21st century.

Congrats :afrog:

:lol:
Imagine what a utterly useless job I have :)

Quote:

---

Originally Posted by crptcblade

I hereby declare all other utterly useless programs obsolete. This is truely the most utterly useless program of the 21st century.

Congrats :afrog:

---

Actually, that just saved me an hour's worth of typing. Thanks, CVMichael!

Now, can you head over to Queen's Park and get McGuinty to rename Family Day into something that's not quite so lame? I don't mind the extra holiday, but that name's just f-ing stupid.

Quote:

---

Originally Posted by Tom Sawyer

Actually, that just saved me an hour's worth of typing. Thanks, CVMichael!

---

How's that ?
Don't tell me you hard-code the dates into your programs ? (I know there are not that many dates... but still I prefer writing a function that calculates them)

[edit]
Actually the Easter I had to hard-code it in... it's too much code/complicated to calculated it (I don't even know how... yet)

We have an XML file that holds all the holidays so our automatic daily processes will know not to run on those days and at the beginning of the year, this one girl in the office goes and enters all the holidays for the current year. She's slow, so she hasn't gotten around to it yet, so I had to do it myself.

There's 10,324 better ways to do this, but I have more important things to do, so I can't be bothered with any of them.

Can i celebrate all these at once?

Quote:

---

Originally Posted by space_monkey

Can i celebrate all these at once?

---

Try it and tell us if it's worth it to celebrate all at once...

If you celebrated these all at once you would be so relaxed your heart would stop beating.

Why, you always relax during holidays ?

Do you always get stressed during holidays?

Either way - you put all that stress into a holiday all at once and yoru heart will stop beating.

Interesting theory.. you must not get many invites for christmas dinners: "Oh **** it, he's died again.. Someone stab him with the the turkey prongs."

Quote:

---

Originally Posted by MaximilianMayrhofer

Someone stab him with the the turkey prongs."

---

Those of us outside Cyprus call it a fork.

Well, in terms of utterly useless.. I would argue that it is not. I did a search 'May 18 2015 Canadian Holiday?' , found this post. Got my question answered. Then signed up to post this response. So it was double useful.

Awww carp! The reputation of chit-chat has been sullied! Ugh! A post has been usefull to someone else.


the end is nigh.


-tg

:wave:

And may you all have the hap, hap, happiest Victoria Day of all time.

I am glad that after this long, something I did is still usefull :)

But... 5 more years, and this thread won't be of use anylonger :(

Now do the rest of the world.

Boxing day Huh? who said you canadians don't like a good fight.

Boxing Day has nothing to do with fights in Canada, it's more of a shopping day: http://www.timeanddate.com/holidays/canada/boxing-day

Quote:

---

Originally Posted by CVMichael

Boxing Day has nothing to do with fights in Canada, it's more of a shopping day: http://www.timeanddate.com/holidays/canada/boxing-day

---

I don't know whether I'm sad you didn't get the joke or sad because that's probably a typical American response.

Well, most Canadians don't like fighting... for the exception of the fights in hockey games... I am one exception because I don't like to watch hockey because of the fighting.

I visited Vancouver a couple of years ago and took in a lower leagues hockey game while I was there. I was most disappointed by the lack of violence on display. The players exhibited horrific levels of fair play and it only kicked off after the game was actually finished. Boo, Canada, Boo.

Mind you, my prior experience of ice hockey was entirely informed by Slapshot.