Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
US Holiday updates utility
Message
 
 
À
19/11/2001 09:28:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00582854
Message ID:
00583396
Vues:
24
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform