Post reply

Holiday Calendar double check

  • November 27, 2013 at 8:45 am

    #395905

    If you have a Calendar Table that also includes common holidays, can you either post a copy of the data, or the code you used to generate it?

    I need a sanity check now that i found an error in mine...

    I've posted this TallyCalendar table(link) in a few posts here on SSC. it builds a calendar from 1900 to the year 3000; it includes all the calculations for holidays i gathered up over time spent here on SSC.

    i saw an article in the news that said that this year is the first time Thanksgiving and Hanukkah fall on the same day, and it won't happen again for 70 thousand years.

    I look at my TallyCalendar, and my dates don't match; it seems like my hanukkah calculation is always one day early, so it seems easy to fix. still digging into the details, but now i want to gut check the whole thing just in case.

    I'm also seeing that the calculation for easter sunday is painfully slow, and want to change that to something better, now that this has my focus again.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 27, 2013 at 8:52 am

    #1669503

    Lowell (11/27/2013)

    ... i saw an article in the news that said that this year is the first time Thanksgiving and Hanukkah fall on the same day, and it won't happen again for 70 thousand years.

    Well I guess I will not have to worry about that in my remaining life time. Thanks for sharing.

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

Viewing 2 posts - 1 through 1 (of 1 total)

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