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:
Re:quit command on NT (1997)
WebCat preferences caching problem (2000)
Triggers under Windows NT (2001)
WCS Newbie question (1997)
Why doesn't it change? (1998)
can WC render sites out? (1997)
Realtor Search (2000)
Loss in Form (1998)
Re:2nd WebCatalog2 Feature Request (1996)
OT: Development contracts (1999)
Date/Time format problems (1997)
Comparing two fields so the match (1998)
New Site Announcement (1998)
How far do [showif]s go? (1997)
Locking up with WebCatalog... (1997)
Calendar using WebCatalog? (1997)
Error Lob.db records error message not name (1997)
Re:quit command on NT (1997)
OS X and Emailer (2002)
Setting up shop (1997)