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:

    
  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 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:

Web Developer Product Awards (1997) no global [username] or [password] displayed ... (1997) ShowNext (1997) Un[url]ize (1999) [BULK] Fwd: [WebDNA] [BULK] WebDNA discovery in the Console - [having many crashes] (2011) [WebDNA] API - YouTube (2011) Problem with new formvariables (2000) Nested Loops and SHOWIFs (1997) Code database (1998) Whats wrong with this code? (1998) Introduction/Tutorial/QuickStart (1997) Caching [include] files ... (1997) Bulk Email >>>>Any ideas? (2001) looping table rows (1999) [WriteFile] problems (1997) Quickly reordering search results (2001) WebCat2b13MacPlugIn - More limits on [include] (1997) ListFiles (1998) [WebDNA] Sendmail with attachment (2019) WebCat & WebTen (1997)