Re: calender with business days
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19736
interpreted = N
texte = >>Has anyone done anything like this with WebCat that skips over weekends>>from a given date? Any jumpstarts (or kick starts) for my creative>>neuronal process would be greatly appreciated.>>I pre-built a database that contains 'deltas', e.g. 2 for saturday and 1>for Sunday (and assumes that all mon-fri have a delta of 0).>>Date_As_Num Delta>736502 2>736503 1>736509 2>736510 1>>736502 is actually a Saturday, something like 8/15/98, represented as>number of days since 00/00/0000. The delta tells how many days to 'jump'>forward if you happen to land on that day. Regular days of the week always>jump forward 1 day, so there's no need to have them in the database. The>advantage to the database is that you can encode holidays with big deltas>to skip past Thanksgiving, Christmas, etc.>>Technical Support | ==== eCommerce and Beyond ====>Pacific Coast Software | WebCatalog, WebMerchant,>11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,>San Diego, CA 92128 | Typhoon>619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/>That seems like a good way for a business calendar. But if the leadtime is 8 business days, there could be two weekends, so the delta would 4 not two. It's a start though. Hmmmmmm. Need chocolate.Sandy
Associated Messages, from the most recent to the oldest:
>>Has anyone done anything like this with WebCat that skips over weekends>>from a given date? Any jumpstarts (or kick starts) for my creative>>neuronal process would be greatly appreciated.>>I pre-built a database that contains 'deltas', e.g. 2 for saturday and 1>for Sunday (and assumes that all mon-fri have a delta of 0).>>Date_As_Num Delta>736502 2>736503 1>736509 2>736510 1>>736502 is actually a Saturday, something like 8/15/98, represented as>number of days since 00/00/0000. The delta tells how many days to 'jump'>forward if you happen to land on that day. Regular days of the week always>jump forward 1 day, so there's no need to have them in the database. The>advantage to the database is that you can encode holidays with big deltas>to skip past Thanksgiving, Christmas, etc.>>Technical Support | ==== eCommerce and Beyond ====>Pacific Coast Software | WebCatalog, WebMerchant,>11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,>San Diego, CA 92128 | Typhoon>619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/>That seems like a good way for a business calendar. But if the leadtime is 8 business days, there could be two weekends, so the delta would 4 not two. It's a start though. Hmmmmmm. Need chocolate.Sandy
Sandra L. Pitner
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Document Contains No Data! (1997)
Quick Question About Sorting (1997)
PCS Frames (1997)
Running 2 two WebCatalog.acgi's (1996)
Problems with [Applescript] (1997)
RE: WebCat and image maps (1997)
Problems w/ heavy use of cart header fields? (1998)
hmmm (2006)
Possible to reset Linux file permissions w/in webcat [shell] ? (2000)
Unexpected error (1997)
Shopping Cart ID (1998)
Windows 2.1b2 Append Bug? (1997)
searching twice on same field (1998)
upgrade? (1997)
LineItem variable set (2007)
Caching [include] files ... (1997)
ErrorMessages.db suggestion (1997)
Location of Browser Info.txt file (1997)
addlineitems (2003)
Can't ping (problem with [shell]) (2006)