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:
shipping & multiple comparisons? (2000)
RAM variables (1997)
Country & Ship-to address & other fields ? (1997)
[shownext max=?] armed (1997)
What really killed WebDNA? (2007)
WebCat2 - Getting to the browser's username/password data (1997)
question: webdelivery folder and file (1997)
shipcost (1997)
Time/date formatting %X doesn't work ... (1997)
Custom error files (1998)
Limiting user access to .tmpl files (1997)
WebCat and search engines (1998)
[OT] Dedicated Image Uploader/Server [/OT] (2003)
WebCatalog/Mac 2.1b2 - PIXO (1997)
WebCat for mass emailings (1997)
Shopping cart not being assigned (1999)
SSL/Non-SSL Database problems (2005)
Outlook Rule (2002)
Fwd: HTML encoding in URLs (1997)
More on the email templates (1997)