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:

WebCat2 beta 11 - new prefs ... (1997) [OT] MacOs IE5 topmargin and leftmargin bug (2000) [SearchString] problem with [search] context (1997) [WebDNA] directory protection questions (2008) exclusive db lock with webcat-3 ? (2000) Fun with dates (1997) Help formatting search results w/ table (1997) Anyone with a solution for this? (2001) Stat analyzer (1997) question: writing files textb in webmerch (1997) [REFERRER] works with form posts (2003) Help! WebCat2 bug (1997) Setting up WebCatalog with Retail Pro data (1996) SHOWIF/HIDEIF empty fields (2005) [subtotal] and others (1997) Associative lookup style? (1997) [WebDNA] Group results but continuous (2016) When to use [convertchars] ?!?!? (2000) SERIAL NUMBER BEING LOST AGAIN!!! (1999) Problems appending to database (1997)