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 LtdTel +44 1224 642960 Fax +44 1224 642962========================================http://www.asylumweb.comEmail: 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:
Superb thanks a lot, that works just fine.Cheers========================================Steve Craig - Asylum Interactive LtdTel +44 1224 642960 Fax +44 1224 642962========================================http://www.asylumweb.comEmail: 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)