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 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 1736502 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: calender with business days (PCS Technical Support 1998)
  2. Re: calender with business days (Sandra L. Pitner 1998)
  3. Re: calender with business days (PCS Technical Support 1998)
  4. calender with business days (Sandra L. Pitner 1998)
>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 1736502 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/ 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)