Re: Working Days - Corrected

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58482
interpreted = N
texte = It still needed a little fine tuning :-) [text show=f]start-date=01/02/2004[/text] [text show=f]end-date=24/02/2004[/text] [math show=f]Total_days={[end-date]}-{[start-date]}+1[/math] [math show=f]working-days=0[/math] [loop start=0&end=[math][Total_days][/math]] [text show=f]day=[format days_to_date %a][math]{[start-date]}+[index][/math][/format][/text] [If (("[day]"="Sat") | ("[day]"="Sun"))] [else][text show=f]working-days=[math][working-days]+1[/math][/text][/else] [/if] [/loop] Total Days: [Total_days] Working days: [working-days] This *should* work OK. Mark. On 18 Jun 2004, at 2:02 pm, 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] > > > > > Mark. > > > > On 18 Jun 2004, at 12:01 pm, Steve Craig wrote: > >> Hi >> >> I have been asked to do something which will involve me counting the >> number >> of working days in a given period e.g. >> >>> From Feb 1st up to, and including Feb 24th there are 17 working days. >> Working days being Mon-Fri, which unfortunately are not mine at the >> moment!!! >> >> Anyone have any pointers on how I might go about doing this? >> >> Thanks in advance >> >> ======================================== >> Steve Craig - Asylum Interactive Ltd >> Tel +44 1224 642960 Fax +44 1224 642962 >> ======================================== >> http://www.asylumweb.com >> Email: steve@asylumweb.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: Working Days - Corrected ( Steve Craig 2004)
  2. Re: Working Days - Corrected ( Bob Minor 2004)
  3. Re: Working Days - Corrected ( Mark Derrick 2004)
It still needed a little fine tuning :-) [text show=f]start-date=01/02/2004[/text] [text show=f]end-date=24/02/2004[/text] [math show=f]Total_days={[end-date]}-{[start-date]}+1[/math] [math show=f]working-days=0[/math] [loop start=0&end=[math][Total_days][/math]] [text show=f]day=[format days_to_date %a][math]{[start-date]}+[index][/math][/format][/text] [If (("[day]"="Sat") | ("[day]"="Sun"))] [else][text show=f]working-days=[math][working-days]+1[/math][/text][/else] [/if] [/loop] Total Days: [Total_days] Working days: [working-days] This *should* work OK. Mark. On 18 Jun 2004, at 2:02 pm, 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] > > > > > Mark. > > > > On 18 Jun 2004, at 12:01 pm, Steve Craig wrote: > >> Hi >> >> I have been asked to do something which will involve me counting the >> number >> of working days in a given period e.g. >> >>> From Feb 1st up to, and including Feb 24th there are 17 working days. >> Working days being Mon-Fri, which unfortunately are not mine at the >> moment!!! >> >> Anyone have any pointers on how I might go about doing this? >> >> Thanks in advance >> >> ======================================== >> Steve Craig - Asylum Interactive Ltd >> Tel +44 1224 642960 Fax +44 1224 642962 >> ======================================== >> http://www.asylumweb.com >> Email: steve@asylumweb.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/ 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:

random within a specified range (2001) Re:What file? (1997) Desperatly seeking (2000) TemplateCacheSize preference! (1998) listfiles-looking for slick solution (1997) Post arguments problem mac? (1997) Javascript/WebCatalog form population (2001) WCf2 and nested tags (1997) WC Database Format (1997) [WebDNA] Encode cookies ONLY via "method=Base64" (2008) [SearchString] problem with [search] context (1997) Re:Emailer setup (1997) RE: [sendmail]- bcc? (1998) Unusual characters in the db ... (2002) WebCat2 - Getting to the browser's username/password data (1997) Templates for Customer Database? (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) [WebDNA] 2nd pair of eyes on redirect please (2011) woops - speed results - right subject (2002) Looking for 5 to 12 shops with 3 URLs & statements (1997)