Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
US Holiday updates utility
Message
 
 
To
19/11/2001 16:21:48
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00582854
Message ID:
00583672
Views:
24
Pete,

This seems like an overkill for the simple thing, I was trying to achieve, but it's good to use in a future, so thanks a lot for sharing.

>>>>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.
>>>
>-snip-
>
>Nadya,
> Here's what i put together.
>
>Open Xcel (2000)
>Put field names in top row
>Format cells; date, pick date style
>Enter beginning date
>Enter second date, this establishes the series spacing
>Click & drag to select the two dates; release
>Click & hold the little square in the lower right corner of the selected cells; cursor changes to a +
>Drag down to the row as far as you want series to go. Release button
>
>You now have a series to work with but no holidays.
>
>Now you need the Palm.
>First address takes you to a selection of 144 Palm software you might be interested in.
>Other addresses are for two holiday listings apps. I like the last file, personally.
>
>http://www.palmgear.com/software/answernew.cfm?sid=86651120011119124129&quicksearch2=holiday&CFID=43344&CFTOKEN=12470436
>
>http://www.palmgear.com/software/showsoftware.cfm?sid=86651120011119124129&prodID=6639
>
>http://www.palmgear.com/software/showsoftware.cfm?sid=86651120011119124129&prodID=15752
>
>http://www.palmgear.com/software/showsoftware.cfms?id=86651120011119124129&prodID=3532
>
>Compare the dates list with your series list. Any hits, go to that date on the Palm and you can see if you need to move the date in the series forward or back.
>
>Select the entire spereadsheet
>Format; cloumn; AutoFit Selection
>Click on cell A1
>Save the Excel file.
>Save As.. dBase III type dbf
>
>HTH.
>ps Thanks for the star. I'm usually not good enough to get one.
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