Formula for 'mfg days'

Maybe to simplistic but ((OrderRel.ReqDate - Prior_Date) / 7 ) * 5

Patrick

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
amfabllc
Sent: Monday, April 03, 2006 10:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Formula for 'mfg days'

Is there a formula in Report Builder that will calculate 'manufacturing
days'? If I wanted to know how many work days (OrderRel.ReqDate) M-F there
are between 01/01/2006 and today, what would you use (subtact out Sat,Sun
and holidays)

Thank you,
Ann




















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
Yahoo! Groups Links






This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.
Is there a formula in Report Builder that will
calculate 'manufacturing days'? If I wanted to know how many work
days (OrderRel.ReqDate) M-F there are between 01/01/2006 and today,
what would you use (subtact out Sat,Sun and holidays)

Thank you,
Ann