Re: Working Days
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58486
interpreted = N
texte = On 18 Jun 2004, at 2:40 pm, Joe D'Andrea wrote: > At 2:02 PM +0100 6/18/04, Mark Derrick wrote: >> This is a little rough, but it should do exactly what you need. >> (You'll need to use variable for the "Start" and "Stop" dates) >> >> [math show=f]Total_days={24/02/2004}-{01/02/2004}[/math] >> [math show=f]working-days=0[/math] >> >> [loop start=0&end=[Total_days]] >> [text show=f]day=[format days_to_date >> %a][math]{01/12/2003}+[index][/math][/format][/text] >> [If (("[day]"="Sat") | ("[day]"="Sun"))] >> [then][/then] >> [else][text >> show=f]working-days=[math][working-days]+1[/math][/text][/else] >> [/if] >> [/loop] >> >> Working days: [working-days] > > Why are you setting [text] variables to the result of [math] > operations in your [else] statement? > > Here's a smaller version (less engine processing) and it doesn't reply > of "if" contexts. > > > [text]startdate=02/01/2004[/text] > [text]enddate=02/24/2004[/text] > > [math show=f]workingdays=0[/math] > > [loop start=[math]{[startdate]}[/math]&end=[math]{[enddate]}[/math]] > [hideif |Sat|Sun|^[format days_to_date %a][index][/format]] > [math show=f]workingdays=[workingdays]+1[/math] > [/hideif] > [/loop] > > Working Days=[workingdays] > Sorry, I cut and pasted some of the code from other snippits I had, and I forgot to change the [text] variable. I always tend to code "long-hand" and then see how many lines I can reduce it to :-) I think this is about has small as it's going to get - the [loop {date}] method is very smart. Mark. ------------------------------------------------------------- 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:
On 18 Jun 2004, at 2:40 pm, Joe D'Andrea wrote: > At 2:02 PM +0100 6/18/04, Mark Derrick wrote: >> This is a little rough, but it should do exactly what you need. >> (You'll need to use variable for the "Start" and "Stop" dates) >> >> [math show=f]Total_days={24/02/2004}-{01/02/2004}[/math] >> [math show=f]working-days=0[/math] >> >> [loop start=0&end=[Total_days]] >> [text show=f]day=[format days_to_date >> %a][math]{01/12/2003}+[index][/math][/format][/text] >> [If (("[day]"="Sat") | ("[day]"="Sun"))] >> [then][/then] >> [else][text >> show=f]working-days=[math][working-days]+1[/math][/text][/else] >> [/if] >> [/loop] >> >> Working days: [working-days] > > Why are you setting [text] variables to the result of [math] > operations in your [else] statement? > > Here's a smaller version (less engine processing) and it doesn't reply > of "if" contexts. > > > [text]startdate=02/01/2004[/text] > [text]enddate=02/24/2004[/text] > > [math show=f]workingdays=0[/math] > > [loop start=[math]{[startdate]}[/math]&end=[math]{[enddate]}[/math]] > [hideif |Sat|Sun|^[format days_to_date %a][index][/format]] > [math show=f]workingdays=[workingdays]+1[/math] > [/hideif] > [/loop] > > Working Days=[workingdays] > Sorry, I cut and pasted some of the code from other snippits I had, and I forgot to change the [text] variable. I always tend to code "long-hand" and then see how many lines I can reduce it to :-) I think this is about has small as it's going to get - the [loop {date}] method is very smart. Mark. ------------------------------------------------------------- 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/
Mark Derrick
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:
[tcp connect] (1998)
WebCatalog dying in WebTen Revisited (1998)
WebTen Memory Error with Plug-In (1998)
More on [purchase] (1998)
shipping costs (1997)
Webcat deletes last line from Excel-saved text db (2004)
target=_blank and form variables (1997)
Encrypting the seed (2001)
Convert Chars Q (2000)
Document Contains No Data! (1997)
Separate SSL Server (1997)
Re1000001: Setting up shop (1997)
Need relative path explanation (1997)
syntax question, not in online refernce (1997)
Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997)
add to cart within a page? (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
RE: E-mailer error codes (1997)
2.01 upgrade problems (1997)
Image size & weight limit on upload (2002)