HELP !!! - Complex scan with DATES and SunDialServices DateTran table

#11

On Wed, 9 Aug 2006 13:29:42 -0400, Larry DiGiovanni wrote:

Quote:

There is code at www.thedbcommunity.com/code/caltable.htm that will build a
calendar table. If you can't modify the one you have, it should be pretty
easy to modify this code to build yourself a new one with any new needed
fields. I don't recall what columns are in Mike's (Sundial's) datetrans.db.

Alternatively, it is wondrously easy to custom build a calendar table in
Quattro (or, presumably, Excel) using @functions for dates. There are
functions that return day of week, day number in month and year, true|false
for workdays, holidays (I think) -- all sorts of obscure stuff. Quattro
(and presumably Excel) exports almost transparently to Paradox.

Jim Hargan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

HELP !!! - Complex scan with DATES and SunDialServices DateTran table

comp.databases.paradox comp.databases.paradox

Re: HELP !!! - Complex scan with DATES and SunDialServices DateTran table - 08-09-2006 , 05:15 PM