469,271 Members | 1,648 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

Getting WorkWeek Values?

M P
I can easily get the current date by using Date(), how about WorkWeek?

Mark
Jul 19 '05 #1
11 3035
What is a "work week"?

Cheers
Ken
"M P" <ma**@textguru.ph> wrote in message
news:uV**************@tk2msftngp13.phx.gbl...
: I can easily get the current date by using Date(), how about WorkWeek?
:
: Mark
:
:
Jul 19 '05 #2
M P
workweek calendar. Like 2004, we have 53 work weeks.
"Ken Schaefer" <ke*******@THISadOpenStatic.com> wrote in message
news:#T*************@TK2MSFTNGP10.phx.gbl...
What is a "work week"?

Cheers
Ken
"M P" <ma**@textguru.ph> wrote in message
news:uV**************@tk2msftngp13.phx.gbl...
: I can easily get the current date by using Date(), how about WorkWeek?
:
: Mark
:
:

Jul 19 '05 #3
What is the difference between a "work week", and a "week"?
What about partial weeks? (eg if 1st January 2004 is a Thursday?)

Cheers
Ken
"M P" <ma**@textguru.ph> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
: workweek calendar. Like 2004, we have 53 work weeks.
:
:
: "Ken Schaefer" <ke*******@THISadOpenStatic.com> wrote in message
: news:#T*************@TK2MSFTNGP10.phx.gbl...
: > What is a "work week"?
: >
: > Cheers
: > Ken
: >
: >
: > "M P" <ma**@textguru.ph> wrote in message
: > news:uV**************@tk2msftngp13.phx.gbl...
: > : I can easily get the current date by using Date(), how about WorkWeek?
: > :
: > : Mark
: > :
: > :
: >
: >
:
:
Jul 19 '05 #4
M P
You don't get what I mean.
Ex. Today is 06-Jul-2004 under WorkWeek 28, for next week its Work Week 29,
and so on...

What I mean with workweek is the work week calendar.
"Ken Schaefer" <ke*******@THISadOpenStatic.com> wrote in message
news:eG*************@tk2msftngp13.phx.gbl...
What is the difference between a "work week", and a "week"?
What about partial weeks? (eg if 1st January 2004 is a Thursday?)

Cheers
Ken
"M P" <ma**@textguru.ph> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
: workweek calendar. Like 2004, we have 53 work weeks.
:
:
: "Ken Schaefer" <ke*******@THISadOpenStatic.com> wrote in message
: news:#T*************@TK2MSFTNGP10.phx.gbl...
: > What is a "work week"?
: >
: > Cheers
: > Ken
: >
: >
: > "M P" <ma**@textguru.ph> wrote in message
: > news:uV**************@tk2msftngp13.phx.gbl...
: > : I can easily get the current date by using Date(), how about WorkWeek? : > :
: > : Mark
: > :
: > :
: >
: >
:
:

Jul 19 '05 #5
"M P" <ma**@textguru.ph> wrote in message
news:Oo**************@TK2MSFTNGP09.phx.gbl...
You don't get what I mean.
Ex. Today is 06-Jul-2004 under WorkWeek 28, for next week its Work Week 29, and so on...


Enter this in the IE Address line and press Enter:

vbscript:DatePart("ww",Date())

vbscript:DatePart("ww",#12/31/2004#)
Jul 19 '05 #6
"McKirahan" <Ne**@McKirahan.com> wrote in message news:<6evGc.31193$a24.28857@attbi_s03>...
"M P" <ma**@textguru.ph> wrote in message
news:Oo**************@TK2MSFTNGP09.phx.gbl...
You don't get what I mean.
Ex. Today is 06-Jul-2004 under WorkWeek 28, for next week its Work Week

29,
and so on...


Enter this in the IE Address line and press Enter:

vbscript:DatePart("ww",Date())

vbscript:DatePart("ww",#12/31/2004#)


Holy cow. never knew ie would do that.
Jul 19 '05 #7
Larry Bud wrote:

Enter this in the IE Address line and press Enter:

vbscript:DatePart("ww",Date())

vbscript:DatePart("ww",#12/31/2004#)


Holy cow. never knew ie would do that.


VBScript or scripting from the location bar? By my observation, all
script-enabled browsers allow some amount of location bar scripting. I
noticed something rather interesting, though:

--- FireFox 0.9.1 and Mozilla 1.7 ---
javascript:alert(123) Success
jscript:alert(123) Nothing
ecmascript:alert(123) Nothing
vbscript:alert(123) Redirect to http://www.vbscript.com/home/

--- IE6 ---
javascript:alert(123) Success
jscript:alert(123) Location changes to vbscript:alert(123)
ecmascript:alert(123) Location changes to javascript:alert(123)
vbscript:alert(123) Success

--- Opera 7.23 ---
javascript:alert(123) Success
jscript:alert(123) Error: Unsupported
ecmascript:alert(123) Error: Unsupported
vbscript:alert(123) Error: Unsupported

Why on Earth would jscript: change to vbscript: ?

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.
Jul 19 '05 #8
M P
Thanks McKirahan!

"McKirahan" <Ne**@McKirahan.com> wrote in message
news:6evGc.31193$a24.28857@attbi_s03...
"M P" <ma**@textguru.ph> wrote in message
news:Oo**************@TK2MSFTNGP09.phx.gbl...
You don't get what I mean.
Ex. Today is 06-Jul-2004 under WorkWeek 28, for next week its Work Week

29,
and so on...


Enter this in the IE Address line and press Enter:

vbscript:DatePart("ww",Date())

vbscript:DatePart("ww",#12/31/2004#)

Jul 19 '05 #9
....no, you don't get what I mean. What the hell is a "work week"? Is there a
definition, or it is just something you made up? Or is it just the week of
the year? And if it's just the week of the year, how do you classify partial
weeks?

Cheers
Ken
"M P" <ma**@textguru.ph> wrote in message
news:Oo**************@TK2MSFTNGP09.phx.gbl...
: You don't get what I mean.
: Ex. Today is 06-Jul-2004 under WorkWeek 28, for next week its Work Week
29,
: and so on...
:
: What I mean with workweek is the work week calendar.
: "Ken Schaefer" <ke*******@THISadOpenStatic.com> wrote in message
: news:eG*************@tk2msftngp13.phx.gbl...
: > What is the difference between a "work week", and a "week"?
: > What about partial weeks? (eg if 1st January 2004 is a Thursday?)
: >
: > Cheers
: > Ken
: >
: >
: > "M P" <ma**@textguru.ph> wrote in message
: > news:%2****************@TK2MSFTNGP09.phx.gbl...
: > : workweek calendar. Like 2004, we have 53 work weeks.
: > :
: > :
: > : "Ken Schaefer" <ke*******@THISadOpenStatic.com> wrote in message
: > : news:#T*************@TK2MSFTNGP10.phx.gbl...
: > : > What is a "work week"?
: > : >
: > : > Cheers
: > : > Ken
: > : >
: > : >
: > : > "M P" <ma**@textguru.ph> wrote in message
: > : > news:uV**************@tk2msftngp13.phx.gbl...
: > : > : I can easily get the current date by using Date(), how about
: WorkWeek?
: > : > :
: > : > : Mark
: > : > :
: > : > :
: > : >
: > : >
: > :
: > :
: >
: >
:
:
Jul 19 '05 #10
> ...no, you don't get what I mean. What the hell is a "work week"? Is there
a
definition, or it is just something you made up? Or is it just the week of
the year?


Ken, there is a generic term that is included in DATEPART calculations that
indicates the week number of the year. For most of us, this is simply the
number of weeks since the first week of the year, going down the calendar.
If the year starts on a Saturday, then Jan 2nd is in week 2.

In VBScript, you can see it this way:

<%
response.write DatePart("ww", date())
%>

In T-SQL:

SELECT DATEPART(WEEK, CURRENT_TIMESTAMP)

You will need to calculate this differently if you have a different
definition of week in your company, e.g. using a calendar table (see
http://www.aspfaq.com/2519). I plan on adding such an example to that
article in the near future.

--
http://www.aspfaq.com/
(Reverse address to reply.)
Jul 19 '05 #11
Hi Aaron,

What I was trying to work out is whether the OP was just asking for the
"week of the year", or does he have some other definition for what a "work
week" is? Maybe "work week" is some kind of technical term or "term of art"
that means something that I'm unfamiliar with.

Cheers
Ken
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:On**************@TK2MSFTNGP11.phx.gbl...
: > ...no, you don't get what I mean. What the hell is a "work week"? Is
there
: a
: > definition, or it is just something you made up? Or is it just the week
of
: > the year?
:
: Ken, there is a generic term that is included in DATEPART calculations
that
: indicates the week number of the year. For most of us, this is simply the
: number of weeks since the first week of the year, going down the calendar.
: If the year starts on a Saturday, then Jan 2nd is in week 2.
:
: In VBScript, you can see it this way:
:
: <%
: response.write DatePart("ww", date())
: %>
:
: In T-SQL:
:
: SELECT DATEPART(WEEK, CURRENT_TIMESTAMP)
:
: You will need to calculate this differently if you have a different
: definition of week in your company, e.g. using a calendar table (see
: http://www.aspfaq.com/2519). I plan on adding such an example to that
: article in the near future.
:
: --
: http://www.aspfaq.com/
: (Reverse address to reply.)
:
:
Jul 19 '05 #12

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by WIWA | last post: by
8 posts views Thread by SenthilVel | last post: by
2 posts views Thread by Kiran Kumar Pinjala | last post: by
3 posts views Thread by Nathan Sokalski | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.