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:

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)