Getting WorkWeek Values?

[M P]

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

Mark

 

[Ken Schaefer]

What is a "work week"?

Cheers
Ken


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

 

[M P]

workweek calendar. Like 2004, we have 53 work weeks.

 

[Ken Schaefer]

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


: workweek calendar. Like 2004, we have 53 work weeks.
:
:
: : > What is a "work week"?
: >
: > Cheers
: > Ken
: >
: >
: > : > : I can easily get the current date by using Date(), how about WorkWeek?
: > :
: > : Mark
: > :
: > :
: >
: >
:
:

 

[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.

 

[McKirahan]

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:

vbscriptatePart("ww",Date())

vbscriptatePart("ww",#12/31/2004#)

 

[Larry Bud]

Enter this in the IE Address line and press Enter:

vbscriptatePart("ww",Date())

vbscriptatePart("ww",#12/31/2004#)

Holy cow. never knew ie would do that.

 

[Dave Anderson]

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.

 

[M P]

Thanks McKirahan!

Enter this in the IE Address line and press Enter:

vbscriptatePart("ww",Date())

vbscriptatePart("ww",#12/31/2004#)

 

[Ken Schaefer]

....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


: 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.
: : > 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
: >
: >
: > : > : workweek calendar. Like 2004, we have 53 work weeks.
: > :
: > :
: > : : > : > What is a "work week"?
: > : >
: > : > Cheers
: > : > Ken
: > : >
: > : >
: > : > : > : > : I can easily get the current date by using Date(), how about
: WorkWeek?
: > : > :
: > : > : Mark
: > : > :
: > : > :
: > : >
: > : >
: > :
: > :
: >
: >
:
:

 

[Aaron [SQL Server MVP]]

...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.

 

[Ken Schaefer]

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


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