Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
US Holiday updates utility
Message
 
 
To
19/11/2001 09:28:58
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00582854
Message ID:
00583396
Views:
23
>>Hi everybody,
>>
>>I'm sure, somebody already wrote a program, which will create a list of US Holidays for given year to insert into Holidays table. Could you please share it with me, so I don't need to re-invent it?
>>
>>We store just 8 Holidays:
>>New Year
>>Presidents Day
>>Memorial Day
>>Independance Day
>>Labor Day
>>Columbus Day
>>Thanksgiving
>>Christmas
>>
>>Unfortunately, I'm not sure in these Holidays definitions, where can I find some info?
>>
>>Thanks in advance.
>
>Nadya,
> I ran into this problem myself. I didn't find a VFP solution, but I did create a lookup table from Xcel. I put some starting dates in the first row and the next date I needed in the second. I then used the series function to put in the full range. About 5 years worth. Then after that I was told to skip the holidays. I used the work day and holiday function to modify the sheet. I verified the dates with a freebie app on my Palm. Converted the speadsheet to VFP and have been using the lookup table since last year.
>
> My Palm dropped its batteries so I lost the name of that proggie. I'm gonna restore it Real Soon Now, but I can get it if you want. As far as the exact procedure in Excel, I can also work that up if you feel it's what you might need.
>
>HTH,
>Pete

This would be really great. For year 2002 I would create them manually, but I'd love to have it automated...
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform