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


"M P" <mark@textguru.ph> wrote in message
news:uVMDmoxYEHA.3988@tk2msftngp13.phx.gbl...
: 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" <kenREMOVE@THISadOpenStatic.com> wrote in message
news:#TJx12xYEHA.992@TK2MSFTNGP10.phx.gbl...

> What is a "work week"?
>
> Cheers
> Ken
>
>
> "M P" <mark@textguru.ph> wrote in message
> news:uVMDmoxYEHA.3988@tk2msftngp13.phx.gbl...
> : I can easily get the current date by using Date(), how about WorkWeek?
> :
> : Mark
> :
> :
>
>

[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


"M P" <mark@textguru.ph> wrote in message
news:%23i7lG7xYEHA.3128@TK2MSFTNGP09.phx.gbl...
: workweek calendar. Like 2004, we have 53 work weeks.
:
:
: "Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in message
: news:#TJx12xYEHA.992@TK2MSFTNGP10.phx.gbl...
: > What is a "work week"?
: >
: > Cheers
: > Ken
: >
: >
: > "M P" <mark@textguru.ph> wrote in message
: > news:uVMDmoxYEHA.3988@tk2msftngp13.phx.gbl...
: > : 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.
"Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in message
news:eGaG7MyYEHA.644@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" <mark@textguru.ph> wrote in message
> news:%23i7lG7xYEHA.3128@TK2MSFTNGP09.phx.gbl...
> : workweek calendar. Like 2004, we have 53 work weeks.
> :
> :
> : "Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in message
> : news:#TJx12xYEHA.992@TK2MSFTNGP10.phx.gbl...
> : > What is a "work week"?
> : >
> : > Cheers
> : > Ken
> : >
> : >
> : > "M P" <mark@textguru.ph> wrote in message
> : > news:uVMDmoxYEHA.3988@tk2msftngp13.phx.gbl...
> : > : I can easily get the current date by using Date(), how about

WorkWeek?

> : > :
> : > : Mark
> : > :
> : > :
> : >
> : >
> :
> :
>
>

[McKirahan]

"M P" <mark@textguru.ph> wrote in message
news:Oo7PE4yYEHA.1656@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#)

[Larry Bud]

"McKirahan" <News@McKirahan.com> wrote in message news:<6evGc.31193$a24.28857@attbi_s03>...

> "M P" <mark@textguru.ph> wrote in message
> news:Oo7PE4yYEHA.1656@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.

[Dave Anderson]

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 [url]http://www.vbscript.com/home/[/url]

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

"McKirahan" <News@McKirahan.com> wrote in message
news:6evGc.31193$a24.28857@attbi_s03...

> "M P" <mark@textguru.ph> wrote in message
> news:Oo7PE4yYEHA.1656@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#)
>
>

[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


"M P" <mark@textguru.ph> wrote in message
news:Oo7PE4yYEHA.1656@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" <kenREMOVE@THISadOpenStatic.com> wrote in message
: news:eGaG7MyYEHA.644@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" <mark@textguru.ph> wrote in message
: > news:%23i7lG7xYEHA.3128@TK2MSFTNGP09.phx.gbl...
: > : workweek calendar. Like 2004, we have 53 work weeks.
: > :
: > :
: > : "Ken Schaefer" <kenREMOVE@THISadOpenStatic.com> wrote in message
: > : news:#TJx12xYEHA.992@TK2MSFTNGP10.phx.gbl...
: > : > What is a "work week"?
: > : >
: > : > Cheers
: > : > Ken
: > : >
: > : >
: > : > "M P" <mark@textguru.ph> wrote in message
: > : > news:uVMDmoxYEHA.3988@tk2msftngp13.phx.gbl...
: > : > : 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
[url]http://www.aspfaq.com/2519[/url]). I plan on adding such an example to that
article in the near future.

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)

[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


"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:OnYtxiDZEHA.2840@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
: [url]http://www.aspfaq.com/2519[/url]). I plan on adding such an example to that
: article in the near future.
:
: --
: [url]http://www.aspfaq.com/[/url]
: (Reverse address to reply.)
:
: