# Getting WorkWeek Values?

Discussion in 'ASP General' started by M P, Jul 6, 2004.

1. ### M PGuest

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

Mark

M P, Jul 6, 2004

2. ### Ken SchaeferGuest

What is a "work week"?

Cheers
Ken

"M P" <> wrote in message
news:...
: I can easily get the current date by using Date(), how about WorkWeek?
:
: Mark
:
:

Ken Schaefer, Jul 6, 2004

3. ### M PGuest

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

"Ken Schaefer" <> wrote in message
news:#...
> What is a "work week"?
>
> Cheers
> Ken
>
>
> "M P" <> wrote in message
> news:...
> : I can easily get the current date by using Date(), how about WorkWeek?
> :
> : Mark
> :
> :
>
>

M P, Jul 6, 2004
4. ### Ken SchaeferGuest

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

Ken Schaefer, Jul 6, 2004
5. ### M PGuest

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" <> wrote in message
news:...
> 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" <> wrote in message
> news:%...
> : workweek calendar. Like 2004, we have 53 work weeks.
> :
> :
> : "Ken Schaefer" <> wrote in message
> : news:#...
> : > What is a "work week"?
> : >
> : > Cheers
> : > Ken
> : >
> : >
> : > "M P" <> wrote in message
> : > news:...
> : > : I can easily get the current date by using Date(), how about

WorkWeek?
> : > :
> : > : Mark
> : > :
> : > :
> : >
> : >
> :
> :
>
>

M P, Jul 6, 2004
6. ### McKirahanGuest

"M P" <> wrote in message
news:...
> 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#)

McKirahan, Jul 6, 2004
7. ### Larry BudGuest

"McKirahan" <> wrote in message news:<6evGc.31193\$a24.28857@attbi_s03>...
> "M P" <> wrote in message
> news:...
> > 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#)

Holy cow. never knew ie would do that.

Larry Bud, Jul 6, 2004
8. ### Dave AndersonGuest

Larry Bud wrote:
>>
>> 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.

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

--- IE6 ---

--- Opera 7.23 ---

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.

Dave Anderson, Jul 6, 2004
9. ### M PGuest

Thanks McKirahan!

"McKirahan" <> wrote in message
news:6evGc.31193\$a24.28857@attbi_s03...
> "M P" <> wrote in message
> news:...
> > 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#)
>
>

M P, Jul 7, 2004
10. ### Ken SchaeferGuest

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

Ken Schaefer, Jul 7, 2004
11. ### Aaron [SQL Server MVP]Guest

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

Aaron [SQL Server MVP], Jul 7, 2004
12. ### Ken SchaeferGuest

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]" <> wrote in message
news:...
: > ...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/