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:
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)