By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,839 Members | 2,270 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,839 IT Pros & Developers. It's quick & easy.

Calculate the number of WEEKDAYS between 2 dates?

P: n/a
Help needed for a Javascript beginner.

As above in the subject... i need a javascript to run this, but not in
the form of a web-page. I want to calculate it between 2 fields in a
database that i have extracted into a report writer.
Look forward to hearing..

Cheers...
SimonC

Jul 23 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
SimonC wrote:
Help needed for a Javascript beginner.

As above in the subject... i need a javascript to run this, but not in
the form of a web-page. I want to calculate it between 2 fields in a
database that i have extracted into a report writer.
Look forward to hearing..

Use the mySQL(or whatever) maths and date functions.
Mick
Jul 23 '05 #2

P: n/a
"SimonC" <si******@yahoo.co.uk> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
Help needed for a Javascript beginner.

As above in the subject... i need a javascript to run this, but not in
the form of a web-page. I want to calculate it between 2 fields in a
database that i have extracted into a report writer.
Look forward to hearing..

Cheers...
SimonC


Is VBScript an option? If so, look at "DateDiff()".

Cut-and-paste the following into an IE Address bar:

vbscript:DateDiff("d",#01/01/2005#,#01/26/2005#)
Jul 23 '05 #3

P: n/a
JRS: In article <EJ********************@comcast.com>, dated Tue, 25 Jan 2005
12:43:05, seen in news:comp.lang.javascript, McKirahan <Ne**@McKirahan.com>
posted :
"SimonC" <si******@yahoo.co.uk> wrote in message
news:11*********************@f14g2000cwb.googlegr oups.com...
As above in the subject...


You could have copied it. Do not presume that the Subject line is readily
visible when the Body is being read. It is:
Calculate the number of WEEKDAYS between 2 dates?

i need a javascript to run this, but not in
the form of a web-page. I want to calculate it between 2 fields in a
database that i have extracted into a report writer.
Look forward to hearing..
Is VBScript an option? If so, look at "DateDiff()".

Cut-and-paste the following into an IE Address bar:

vbscript:DateDiff("d",#01/01/2005#,#01/26/2005#)


It would help if you were both to read and understand the question
before answering. Your code gives me 25.

The OP is posting from the UK; he cannot be expected to want FFF dates.

The difference in those dates is 25 days.
There are 24 days between those dates.
There are 17 weekdays between those dates, or 18 inclusive (Sat..Wed).

You could have answered with corresponding javascript:
javascript:Math.round((new Date("2005/01/26")-new Date("2005/01/01"))/864e5)
also gives 25 from the address bar.

You do not need DateDiff :
vbscript:CDate(#01/26/2005#)-CDate(#01/01/2005#)
and indeed vbscript:#01/26/2005#-#01/01/2005#
give 25 too.
The OP can find what he needs in js-date7.htm, via FAQ; see below.
He will have to consider the meaning of "between".

Alternatively, the following method will do well enough for short
intervals (adapt for desired end-effects) :

D = new Date("2005/01/01")
E = new Date("2005/01/26").setHours(12)
N = 0
while (D<E) {
if (D.getDay()%6!=0) N++
D.setDate(D.getDate()+1)
}
N
--
John Stockton, Surrey, UK. ?@merlyn.demon.co.uk Turnpike v4.00 IE 4
<URL:http://www.jibbering.com/faq/> JL/RC: FAQ of news:comp.lang.javascript
<URL:http://www.merlyn.demon.co.uk/js-index.htm> jscr maths, dates, sources.
<URL:http://www.merlyn.demon.co.uk/> TP/BP/Delphi/jscr/&c, FAQ items, links.
Jul 23 '05 #4

P: n/a
Dr John Stockton wrote:
[...]
The OP can find what he needs in js-date7.htm, via FAQ; see below.
And the request for "weekdays" suggest business days, which are
affected by public holidays. Therefore reference to a calendar
may be required.

Allowing for international (or even interstate) variances
suggests some serious issues with attempting to accurately count
the number of business or working days.
Alternatively, the following method will do well enough for short
intervals (adapt for desired end-effects) :

D = new Date("2005/01/01")
E = new Date("2005/01/26").setHours(12)
N = 0
while (D<E) {
if (D.getDay()%6!=0) N++
D.setDate(D.getDate()+1)
}
N


Neat accommodation of Sunday being day zero. Then again, the
test would be even simpler if Monday was zero...

--
Fred
Jul 23 '05 #5

P: n/a
JRS: In article <vP*****************@news.optus.net.au>, dated Thu, 27
Jan 2005 01:52:27, seen in news:comp.lang.javascript, Fred Oz
<Oz****@iinet.net.auau> posted :
Dr John Stockton wrote:
[...]
The OP can find what he needs in js-date7.htm, via FAQ; see below.
And the request for "weekdays" suggest business days, which are
affected by public holidays. Therefore reference to a calendar
may be required.


Since the OP was posting from UK, I took him to mean what he wrote.
Allowing for international (or even interstate) variances
suggests some serious issues with attempting to accurately count
the number of business or working days.
Interstate - what's that? <g>

But, at least in the UK, there are some things for which Mon-Fri differs
from Sat,Sun without being affected by holidays. For example, my
preferred Internet dial-up number currently works all day Sat,Sun but on
other days not between 08:00 & 18:00 - and that is totally unaffected by
Christmas Day and other holidays.

if (D.getDay()%6!=0) N++

Neat accommodation of Sunday being day zero.
Available to all who read the newsgroup FAQ with care; as is stuff on
allowing for holidays.
Then again, the
test would be even simpler if Monday was zero...


Or if Sunday were seven, as called for by ISO 8601.

--
John Stockton, Surrey, UK. ?@merlyn.demon.co.uk Turnpike v4.00 IE 4
<URL:http://www.jibbering.com/faq/> JL/RC: FAQ of news:comp.lang.javascript
<URL:http://www.merlyn.demon.co.uk/js-index.htm> jscr maths, dates, sources.
<URL:http://www.merlyn.demon.co.uk/> TP/BP/Delphi/jscr/&c, FAQ items, links.
Jul 23 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.