Calculate Week Number in Crystal Reports

Yahoo Archive
1
I think I misunderstood your question when I answered the first time . In
Crystal 8.0 try this WeekOfYear({orderrel.NEEDBYDATE})
also see K.B. article
http://support.crystaldecisions.com/library/kbase/articles/c2006747.asp
<http://support.crystaldecisions.com/library/kbase/articles/c2006747.asp>
for more ways to tweak the formula results.

Good luck

Dan


-----Original Message-----
From: Dan Shallbetter [mailto:dans@...]
Sent: Friday, March 22, 2002 2:35 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Calculate Week Number in Crystal Reports


Hello Chris try this formula DateDiff
("w",{orderhed.ORDERDATE},{orderrel.NEEDBYDATE})

Dan Shallbetter
States Electric Mfg.

definitely not a Crystal Guru


-----Original Message-----
From: cliu72 [mailto:cliu@...]
Sent: Friday, March 22, 2002 1:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Calculate Week Number in Crystal Reports


Crystal Report Gurus:
Can anyone tell me how to calculate the week number in Crystal
Reports? We use week numbers here and would like them to print onto
the sales orders with regards to the NeedByDate.
Thanks in advance.
Chris Liu
Information Systems
Servo Magnetics Inc.






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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=215002.1818248.3328688.1261774/D=egroupweb/S=17050071
83:HM/A=847665/R=0/*http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1016829317%
3eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>


<http://us.adserver.yahoo.com/l?M=215002.1818248.3328688.1261774/D=egroupmai
l/S=1705007183:HM/A=847665/rand=601254224>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<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]
2
Crystal Report Gurus:
Can anyone tell me how to calculate the week number in Crystal
Reports? We use week numbers here and would like them to print onto
the sales orders with regards to the NeedByDate.
Thanks in advance.
Chris Liu
Information Systems
Servo Magnetics Inc.
3
Hello Chris try this formula DateDiff
("w",{orderhed.ORDERDATE},{orderrel.NEEDBYDATE})

Dan Shallbetter
States Electric Mfg.

definitely not a Crystal Guru


-----Original Message-----
From: cliu72 [mailto:cliu@...]
Sent: Friday, March 22, 2002 1:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Calculate Week Number in Crystal Reports


Crystal Report Gurus:
Can anyone tell me how to calculate the week number in Crystal
Reports? We use week numbers here and would like them to print onto
the sales orders with regards to the NeedByDate.
Thanks in advance.
Chris Liu
Information Systems
Servo Magnetics Inc.






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