BOM Report and Week Calculation

Gary,
here is a copy of my formula out or RB. Looks like I changed it a bit to work for this year.

IIF((ReqDueDate - DATE("12/31/01")) = 0,(((ReqDueDate - DATE("12/31/01")) / 7) - 52),(TRUNCATE((ReqDueDate - date("12/31/01")) / 7, 0)) + 1 - 52)

here is a copy i use in crystal also.

if(({JobHead.ReqDueDate} - Date (2001,12,31))= 0) then
((({JobHead.ReqDueDate} - Date (2001,12,31)) / 7) - 52)
else (Truncate(({JobHead.ReqDueDate} - Date (2001,12,31))
/ 7,0 )) + 1 - 52
hope this works for you.
dennis
----- Original Message -----
From: Gary Parfrey
To: vantage@yahoogroups.com
Sent: Friday, March 28, 2003 10:11 AM
Subject: RE: [Vantage] BOM Report and Week Calculation


Hi Dennis

Thanks for the reply. Is that a report builder or Crystal calculation
or both. I'm having a problem getting it working. Says there is a
missing bracket. Is there any chance you could revalidate it.

Gary

-----Original Message-----
From: Dennis Houghton [mailto:dennis@...]
Sent: 28 March 2003 15:13
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BOM Report and Week Calculation



Gary,


-----Original Message-----
From: Dennis Houghton [mailto:dennis@...]
Sent: 28 March 2003 15:13
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BOM Report and Week Calculation


Gary,

I use this formula for a couple of reports, it came from someone in this
group.
you may have to change the year in the fields and/or modify for your
use.

dennis

IIF((Date_rb - DATE("01/01/00")) MODULO 7 = 0, ((Date_ rb -
DATE("01/01/00"))/7,(TRUNCATE((Date_rb - date("01/01/00"))/7,0) + 1))
----- Original Message -----
From: Gary Parfrey
To: vantage@yahoogroups.com
Sent: Friday, March 28, 2003 8:51 AM
Subject: [Vantage] BOM Report and Week Calculation


Hi Group

Can anybody help me with a report builder BOM report

and/or

the report builder calculation to turn the date into a week number?

Thanks in Advance


Gary Parfrey
Operations Manager
Steatite Limited
TEL: 0044 (0)1527 406880
DDI: 0044 (0)1527 406886
FAX: 0044 (0)1527 406889
www.steatite.co.uk


Yahoo! Groups Sponsor



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]



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/



________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________

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]
Hi Group

Can anybody help me with a report builder BOM report

and/or

the report builder calculation to turn the date into a week number?

Thanks in Advance


Gary Parfrey
Operations Manager
Steatite Limited
TEL: 0044 (0)1527 406880
DDI: 0044 (0)1527 406886
FAX: 0044 (0)1527 406889
www.steatite.co.uk
Gary,

I use this formula for a couple of reports, it came from someone in this group.
you may have to change the year in the fields and/or modify for your use.

dennis

IIF((Date_rb - DATE("01/01/00")) MODULO 7 = 0, ((Date_ rb -
DATE("01/01/00"))/7,(TRUNCATE((Date_rb - date("01/01/00"))/7,0) + 1))
----- Original Message -----
From: Gary Parfrey
To: vantage@yahoogroups.com
Sent: Friday, March 28, 2003 8:51 AM
Subject: [Vantage] BOM Report and Week Calculation


Hi Group

Can anybody help me with a report builder BOM report

and/or

the report builder calculation to turn the date into a week number?

Thanks in Advance


Gary Parfrey
Operations Manager
Steatite Limited
TEL: 0044 (0)1527 406880
DDI: 0044 (0)1527 406886
FAX: 0044 (0)1527 406889
www.steatite.co.uk


Yahoo! Groups Sponsor



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]
Hi Dennis

Thanks for the reply. Is that a report builder or Crystal calculation
or both. I'm having a problem getting it working. Says there is a
missing bracket. Is there any chance you could revalidate it.

Gary

-----Original Message-----
From: Dennis Houghton [mailto:dennis@...]
Sent: 28 March 2003 15:13
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BOM Report and Week Calculation



Gary,


-----Original Message-----
From: Dennis Houghton [mailto:dennis@...]
Sent: 28 March 2003 15:13
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BOM Report and Week Calculation


Gary,

I use this formula for a couple of reports, it came from someone in this
group.
you may have to change the year in the fields and/or modify for your
use.

dennis

IIF((Date_rb - DATE("01/01/00")) MODULO 7 = 0, ((Date_ rb -
DATE("01/01/00"))/7,(TRUNCATE((Date_rb - date("01/01/00"))/7,0) + 1))
----- Original Message -----
From: Gary Parfrey
To: vantage@yahoogroups.com
Sent: Friday, March 28, 2003 8:51 AM
Subject: [Vantage] BOM Report and Week Calculation


Hi Group

Can anybody help me with a report builder BOM report

and/or

the report builder calculation to turn the date into a week number?

Thanks in Advance


Gary Parfrey
Operations Manager
Steatite Limited
TEL: 0044 (0)1527 406880
DDI: 0044 (0)1527 406886
FAX: 0044 (0)1527 406889
www.steatite.co.uk


Yahoo! Groups Sponsor



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]



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/



________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
Rb: IIF((Date_rb - DATE("01/01/03")) MODULO 7 = 0, ((Date_rb -
DATE("01/01/03")) / 7),(TRUNCATE((Date_rb - date("01/01/03")) / 7,0) + 1))



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