Dates and Holidays

[KOVMoe]

I have begun a quest to figure out holidays, in CFM only. I have to present reports that will, on Monday Mornings, show last week. Not a problem. But the upcoming Holiday does throw a wrench in the works. New Years, 4th of July, Christmas and New Years Eve are all easy. How do I go about figuring Memorial Day, Labor Day, Thanksgiving and the Friday after Thanksgiving?

Thank you,

Moe-King of the Village Idiots.

"When in trouble,
when in doubt;
Run in circles-
SCREAM & SHOUT!!"
Burma Shave

 

[ecobb]

http://www.cflib.org/library.cfm?ID=13

About half way down there's a section called "Holidays".



Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[r937]

use a calendar table, with one row per date and a holiday flag (with optional varchar field for holiday name)

you will have to populate it with a few years of data, but this is a trivial exercise which will likely take less time than writing the code to call all the necessary functions (like isEaster, isLabourDay, isThanksgiving, etc.)

i usually do it in Excel (because of its neat "series" function which can increment dates) and then import the data

r937.com | rudy.ca