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:
WebCat2 Append problem (B14Macacgi) (1997)
Questions on Mac WC 3.0.5b13 (2000)
Text limits in NT version? (1997)
Range search (2003)
Why don't my carts expire (1998)
attn: smitmicro - cart limitation (2002)
Still More on EudoraPro Email (1998)
b12 cannot limit records returned and more. (1997)
Re:no [search] with NT (1997)
creating a ShipCosts database (1997)
Speed Test Results Dell 2650 Xeon 2.4ghz (2002)
SV: Text in coloums... (2000)
OT: Let's see your workspace... (2005)
Null Chars (1999)
[WebDNA] shopping sites and the "old commerce tags" (2012)
Exclude by date - multiple (1997)
WebDNA Speed Test (2008)
Re[2]: php vs WebCatalog (2000)
keep W* in front applescript? (1998)
Limiting user access to .tmpl files (1997)