Week Numbers in Report Builder

Yahoo Archive
1
Week of the month or Julian Week?

-----Original Message-----
From: gparfrey [mailto:garyp@...]
Sent: Wednesday, December 05, 2001 11:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Week Numbers in Report Builder


Hi Group

Is there any functionality or calculated field in Report Builder that
will give me the week number.

Regards


Gary Parfrey
Steatite Group Limited



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
Hi Group

Is there any functionality or calculated field in Report Builder that
will give me the week number.

Regards


Gary Parfrey
Steatite Group Limited
3
Use the following formula in a calculated field to generate a week number.
Adjusted the named dated fields accordingly.

IIF((LaborHed.ClockInDate - DATE("01/01/00")) Modulo 7 =
0,((LaborHed.ClockInDate - DATE("01/01/00")) /
7),(TRUNCATE((LaborHed.ClockInDate - DATE("01/01/00")) / 7,0) + 1))

Shirley H. Graver
(End User)
Systems Administrator
Rubber Associates Inc.

-----Original Message-----
From: gparfrey [mailto:garyp@...]
Sent: Wednesday, December 05, 2001 12:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Week Numbers in Report Builder

Hi Group

Is there any functionality or calculated field in Report Builder that
will give me the week number.

Regards


Gary Parfrey
Steatite Group Limited




Yahoo! Groups Sponsor
ADVERTISEMENT

<http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050071
83:HM/A=879173/R=0/*http://www.fastweb.com/ib/yahoo-76f>


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


[Non-text portions of this message have been removed]