>>>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=12470436http://www.palmgear.com/software/showsoftware.cfm?sid=86651120011119124129&prodID=6639http://www.palmgear.com/software/showsoftware.cfm?sid=86651120011119124129&prodID=15752http://www.palmgear.com/software/showsoftware.cfms?id=86651120011119124129&prodID=3532Compare 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...