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:
POS (2000)
Practice runs ? (1997)
[Sum] function? (1997)
HideIf ip= OR ip= (1998)
WebCat2: Found Items syntax, etc. (1997)
WCS Newbie question (1997)
Size/Color Options (2002)
rotating thumbnails (1997)
Newbie problem blah blah blah (1997)
Longer .extensions with Windows? (1998)
Count regular expressions in a file (2007)
New WebDNA Example from Olin -- (1998)
show all problem (1997)
Converting characters to numbers ... (1997)
sku, title, price not showing up (1998)
Great product and great job ! (1997)
SOLUTION? Me know logical no need (2002)
Some Questions (1997)
[WebDNA] Does anyone host webdna sites? (2016)
WebCat2 Append problem (B14Macacgi) (1997)