Re: Working Days - Corrected
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58484
interpreted = N
texte = Good point but not required in my case. Thanks ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1224 642960 Fax +44 1224 642962 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com ======================================== > From: Bob Minor
> Reply-To: "WebDNA Talk" > Date: Fri, 18 Jun 2004 09:36:43 -0400 > To: "WebDNA Talk" > Subject: Re: Working Days - Corrected > > what about holidays? > > On Jun 18, 2004, at 9:31 AM, Mark Derrick wrote: > >> 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/ > > > ------------------------------------------------------------- > 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:
Good point but not required in my case. Thanks ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1224 642960 Fax +44 1224 642962 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com ======================================== > From: Bob Minor > Reply-To: "WebDNA Talk" > Date: Fri, 18 Jun 2004 09:36:43 -0400 > To: "WebDNA Talk" > Subject: Re: Working Days - Corrected > > what about holidays? > > On Jun 18, 2004, at 9:31 AM, Mark Derrick wrote: > >> 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/ > > > ------------------------------------------------------------- > 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:
DD/MM/YY reseting (1999)
[WebDNA] Accepting Payments on Site (2013)
Mime-Version in email header (1997)
WebCat2b13MacPlugIn - syntax to convert date (1997)
multi-part email help (2001)
Separate SSL Server (1997)
shownext not showing next...still r2 (1997)
Frames and WebCat (1997)
Mondo amounts of Mail [long] (1999)
Multiple Currencies (2002)
HELP WITH DATES (1997)
NT Photo manip. util. needed (2000)
Blank orders after update to 5.1 (2003)
Protect and Serve (1999)
Field validation problem (1999)
Problems reading files created by WC (1997)
Pass a form (2003)
random images (1997)
can WC render sites out? (1997)
WebCat2.0 acgi vs plugin (1997)