Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
US Holiday updates utility
Message
From
19/11/2001 09:52:35
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00582854
Message ID:
00583408
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...

OK Nadya,
I've got to finish my work here, but hopefully I should have something for you by the end of the day.
Peter Adams
FoxPro Programmer
Compu-Mail

Heisenberg was probably right...
Previous
Reply
Map
View

Click here to load this message in the networking platform