Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
US Holiday updates utility
Message
From
19/11/2001 09:28:58
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00582854
Message ID:
00583389
Views:
27
This message has been marked as a message which has helped to the initial question of the thread.
>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
Peter Adams
FoxPro Programmer
Compu-Mail

Heisenberg was probably right...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform