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:
WebDNA equivalent for $REQUEST_URI (2004)
[WriteFile] problems (1997)
serial number not working (1998)
[WebDNA] v.7 and eCommerce (2012)
sorting dates (1999)
PCS Frames (1997)
Emailer Set Up (1997)
Emailer problem with WC 2.1, NT, WebSite 2.1 (1998)
Trouble with formula.db (1997)
WC2b12: Yes, Formulas.db is for real (1997)
stumped (2001)
Opinion: [input] should be called [output] ... (1997)
Orders.db Update (2003)
log out (2001)
syntax question, not in online refernce (1997)
WebCat2b13 Command Reference Doc error (1997)
Checkboxes (1998)
Location of Browser Info.txt file (1997)
problems with WebCat-Plugin ()
Help with Repost Data msg from form (1997)