I used this as a calculated field in RB and substituted Reqduedate and grouped on this field to give a shop load report for each week no. Seems to work for the most part except I have some jobs that show in the wrong week according to date due.
Any ideas on how to correct this? Could someone explain how this calculation works to get a week of the year number, I don't really understand date calculations.
Thanks
Dennis H
Any ideas on how to correct this? Could someone explain how this calculation works to get a week of the year number, I don't really understand date calculations.
Thanks
Dennis H
----- Original Message -----
From: Shirley Graver
To: vantage@yahoogroups.com
Sent: Friday, December 07, 2001 5:26 AM
Subject: RE: [Vantage] Crystal Calculation
The following formula works in Report Builder, I've never tried it in
crystal.
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: Dr.Byte [mailto:drbyte@...]
Sent: Thursday, December 06, 2001 3:35 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Calculation
On Thu, 6 Dec 2001 15:20:39 -0500, you wrote:
>Hi Wendy,
> You're going to have to wrap a Date(01/01/2001) date function
>around those dates so crystal sees them in the right format.
>Shirley H. Graver
>(End User)
>Systems Administrator
>Rubber Associates Inc
.
Little question in between this,
Is het possible to get the weeknumber out of a date...????
>-----Original Message-----
>From: Wendy Bowen (Pursche) [mailto:wpursche@...]
>Sent: Thursday, December 06, 2001 3:09 PM
>To: vantage@yahoogroups.com
>Subject: [Vantage] Crystal Calculation
>
>I'm trying to calculate a "week begin date". When I create the formula in
>Crystal it keeps giving me the error "a number or currency amount is
>required here". I'm not sure what number to put in the "?".
>
> 01/07/2001 + (Int(?({LaborHed.ClockInDate} - 01/07/2001) /
>7) * 7)
>
>Any suggestions guys?
>
>Wendy Bowen
>Network Administrator
>Schmald Tool & Die, Inc.
>(810) 743-1600 ext.323
>wpursche@...
>
>
>[Non-text portions of this message have been removed]
>
>
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
>
><
http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050071
>83:HM/A=879171/R=0/* http://www.fastweb.com/ib/yahoo-57f>
>
>
>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]
>
>
>
>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/
>
>
--=== Groeten René ===--
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]
Yahoo! Groups Sponsor
ADVERTISEMENT
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.
[Non-text portions of this message have been removed]