Re: Working Days

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58481
interpreted = N
texte = Superb thanks a lot, that works just fine. Cheers ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1224 642960 Fax +44 1224 642962 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com ======================================== > From: Mark Derrick > Reply-To: "WebDNA Talk" > Date: Fri, 18 Jun 2004 14:02:06 +0100 > To: "WebDNA Talk" > Subject: Re: Working Days > > 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 ( Mark Derrick 2004)
  2. Re: Working Days ( Joe D'Andrea 2004)
  3. Re: Working Days - Corrected ( Steve Craig 2004)
  4. Re: Working Days - Corrected ( Bob Minor 2004)
  5. Re: Working Days - Corrected ( Mark Derrick 2004)
  6. Re: Working Days ( Steve Craig 2004)
  7. Re: Working Days ( Mark Derrick 2004)
  8. Working Days ( Steve Craig 2004)
  9. How many working days? ( This)
Superb thanks a lot, that works just fine. Cheers ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1224 642960 Fax +44 1224 642962 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com ======================================== > From: Mark Derrick > Reply-To: "WebDNA Talk" > Date: Fri, 18 Jun 2004 14:02:06 +0100 > To: "WebDNA Talk" > Subject: Re: Working Days > > 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/ Steve Craig

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:

A dynamic database. (1997) WebCat2b15MacPlugin - showing [math] (1997) Wrong? (1999) os 8.5 (1999) cart limit (2002) Re:Virtual hosting and webcatNT (1997) Database (2000) possible, WebCat2.0 and checkboxes-restated (1997) FREE Web Server Monitor FREE (1997) taxRate is fine but taxTotal isn't (1997) strange math (2004) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) emailer (1997) Locking up with WebCatalog... (1997) problems with 2 tags (1997) WebCat2 - many [carts] on one template page? (1997) Weird Math and SV (1997) Webstar and WebCatalog (1999) Secure server question (1997) pc (1997)