Re: Business day calculator

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 66359
interpreted = N
texte = Maybe set up a temp table with your holidays, if the resulting date matches one of the listed holidays, then add a day and recheck. If I get some time later I will mess with it. Dan Strong wrote: > What about holidays? :) > -Dan > > On Thu, 02 Mar 2006 07:49:58 -0500 > Adam O'Connor wrote: >> Try this: >> >> >> Today's date: [date] >>
>> You package will be delivered by: (Today's date + 5 business days) >> >> [switch value=[date %a]] >> [case value=mon][Math date]{[date]}+{00/07/0000}[/Math][/case] >> [case value=tue][Math date]{[date]}+{00/06/0000}[/Math][/case] >> [case value=wed][Math date]{[date]}+{00/05/0000}[/Math][/case] >> [case value=thu][Math date]{[date]}+{00/05/0000}[/Math][/case] >> [case value=fri][Math date]{[date]}+{00/05/0000}[/Math][/case] >> [case value=sat][Math date]{[date]}+{00/05/0000}[/Math][/case] >> [case value=sun][Math date]{[date]}+{00/05/0000}[/Math][/case] >> [/switch] >> >> >> >> >> >> >> >> Pat McCormick wrote: >>> I would like to calculate the number of business days from any given >>> date. >>> >>> Rather than have my site say "You'll receive your order in 5 >>> business days.", I'd rather say "You'll receive your order on >>> xx/xx/xxxx.", which would be 5 business days from the system date. >>> >>> Has anyone coded this and could you help out a fellow wDNAr? >>> >>> Thanks, >>> Pat >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> Web Archive of this list is at: http://webdna.smithmicro.com/ >> >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> Web Archive of this list is at: http://webdna.smithmicro.com/ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Business day calculator ( Adam O'Connor 2006)
  2. Re: Business day calculator ( "Dan Strong" 2006)
  3. Re: Business day calculator ( Adam O'Connor 2006)
  4. Business day calculator ( Pat McCormick 2006)
Maybe set up a temp table with your holidays, if the resulting date matches one of the listed holidays, then add a day and recheck. If I get some time later I will mess with it. Dan Strong wrote: > What about holidays? :) > -Dan > > On Thu, 02 Mar 2006 07:49:58 -0500 > Adam O'Connor wrote: >> Try this: >> >> >> Today's date: [date] >>
>> You package will be delivered by: (Today's date + 5 business days) >> >> [switch value=[date %a]] >> [case value=mon][Math date]{[date]}+{00/07/0000}[/Math][/case] >> [case value=tue][Math date]{[date]}+{00/06/0000}[/Math][/case] >> [case value=wed][Math date]{[date]}+{00/05/0000}[/Math][/case] >> [case value=thu][Math date]{[date]}+{00/05/0000}[/Math][/case] >> [case value=fri][Math date]{[date]}+{00/05/0000}[/Math][/case] >> [case value=sat][Math date]{[date]}+{00/05/0000}[/Math][/case] >> [case value=sun][Math date]{[date]}+{00/05/0000}[/Math][/case] >> [/switch] >> >> >> >> >> >> >> >> Pat McCormick wrote: >>> I would like to calculate the number of business days from any given >>> date. >>> >>> Rather than have my site say "You'll receive your order in 5 >>> business days.", I'd rather say "You'll receive your order on >>> xx/xx/xxxx.", which would be 5 business days from the system date. >>> >>> Has anyone coded this and could you help out a fellow wDNAr? >>> >>> Thanks, >>> Pat >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> Web Archive of this list is at: http://webdna.smithmicro.com/ >> >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> Web Archive of this list is at: http://webdna.smithmicro.com/ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Adam O'Connor

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:

trouble updating records in database (1998) Help! WebCat2 bug (1997) [LOOKUP] (1997) Upgrading old WebCat Database Files (1997) Multiple fields on 1 input (1997) Help! WebCat2 bug (1997) WebCat2 - [format thousands] (1997) RePost: NAT and the CART (1999) javascript for dynamic pulldowns? (1998) WC2.0 Memory Requirements (1997) [WebDNA] Using Grep to pull links from a variable (2014) Setting up shop (1997) Quit revisited (1997) Security (2000) shortening the cart (1998) taxTotal, grandTotal (1997) Modifying Carts (1999) WebDNA Server (2007) Pass Thru Page? (1998) Fields font size (2003)