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