Re: calender with business days
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19731
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 1for Sunday (and assumes that all mon-fri have a delta of 0).Date_As_Num Delta736502 2736503 1736509 2736510 1736502 is actually a Saturday, something like 8/15/98, represented asnumber 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 alwaysjump forward 1 day, so there's no need to have them in the database. Theadvantage to the database is that you can encode holidays with big deltasto 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 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
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 1for Sunday (and assumes that all mon-fri have a delta of 0).Date_As_Num Delta736502 2736503 1736509 2736510 1736502 is actually a Saturday, something like 8/15/98, represented asnumber 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 alwaysjump forward 1 day, so there's no need to have them in the database. Theadvantage to the database is that you can encode holidays with big deltasto 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 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
Nesting format tags (1997)
Mac OS X problem (2003)
users.db (1999)
[OT] Linux Mailservers (2003)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Secure Server (1997)
authenticating a second user (1997)
my price won't move (1997)
WebCat Documentation (was [platform] tag?) (1998)
Next X hits (1996)
Major Security Hole (1998)
WebCatalog can't find database (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[WriteFile] problems (1997)
WebCat 4.0 & WebMerchant (2000)
RE: URL too Long? (1997)
Multiple catalog databases and showcart (1997)
Help! WebCat2 bug (1997)
Limitations on fields? Server is crashing (1997)
[REQ] Improved SQL context (2000)