Workdays formula in report builder

Remember to scan for non work days in the ProdCal. Those would be
holidays and other non-scheduled work days. You will need to find a way
to work those days out some how.


Charlie Smith
Smith Business Services / 2W Technologies LLC
www.vistaconsultant.com <http://www.vistaconsultant.com/> /
www.2wtech.com <http://www.2wtech.com/>


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of amfabllc
Sent: Monday, January 08, 2007 5:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: workdays formula in report builder



What's really scary is that I follow you. Years ago I made a chart
of what you are talking about and wrote a few reports from it -
hopefully I still have it somewhere. I just searched and read 9 old
posts, and I must say this looks the most promising. I thought I
probably overlooked the prodcal when I wrote that years ago, but I
guess not. I am on 5.0, is there something prettier to work with to
link to the prodcal in 6.1 or 8.03? Thank you very much for your
help, at least I know what direction to go now.

Ann

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Todd Caughey" <caugheyt@...> wrote:
>
> I don't have it all worked out but one approach....(certainly not
elegant)
>
> 1. For the Work Center add up the # of actual work days in the
week:
> Day1 = IIF(WorkWeek[1],1,0)
> Day2 = IIF(WorkWeek[2],1,0)
> etc.... then WokDays = Day1 + Day2 + Day3 etc....thru Day7
> 2. 30-Workdays-Out =
> IIF(WorkDays = 5,Date_rb + 42,
> IIF(WorkDays = 6,Date_rb + 35,
> WorkDays = 7,Date_rb + 30))
> Assuming all work centers work at least 5 days. Premise is (30 /
# workdays) X 7.
> Part not worked out....adjusting for starting day of week which
is probably weekday # (from formula) plus/minus some constant.
Today being a Monday or a Friday might make a difference in the
number of work days.
> Then use the resulting date in the filter. Again, this is "an
approach" not a tested solution.
>
> ReqDate from Order Release? Then link to job via JobProd table.
> -Todd C.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of amfabllc
> Sent: Monday, January 08, 2007 2:19 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] workdays formula in report builder
>
>
>
> I need to make a report builder report, in it I need to use '30
days
> from today'. I would really like to use the production calendar in
> Vantage if possible so that once the report is finished, as long
as
> they keep the calendar up to date, the report will be correct.
>
> I am in the ProdCal table, I understand Sun=1, Mon=2, etc...
>
> Can someone give me an example of what to use for a filter line
for:
> ReqDate <= 30 workdays from today
>
> I will also need to link it to the job due to I will need filter
for
> engineered but not release. Any suggestions? Is there something
else
> you guys use? Vantage 5.00.329.
>
> Thanks,
> Ann
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>






[Non-text portions of this message have been removed]
I need to make a report builder report, in it I need to use '30 days
from today'. I would really like to use the production calendar in
Vantage if possible so that once the report is finished, as long as
they keep the calendar up to date, the report will be correct.

I am in the ProdCal table, I understand Sun=1, Mon=2, etc...

Can someone give me an example of what to use for a filter line for:
ReqDate <= 30 workdays from today

I will also need to link it to the job due to I will need filter for
engineered but not release. Any suggestions? Is there something else
you guys use? Vantage 5.00.329.

Thanks,
Ann
I don't have it all worked out but one approach....(certainly not elegant)

1. For the Work Center add up the # of actual work days in the week:
Day1 = IIF(WorkWeek[1],1,0)
Day2 = IIF(WorkWeek[2],1,0)
etc.... then WokDays = Day1 + Day2 + Day3 etc....thru Day7
2. 30-Workdays-Out =
IIF(WorkDays = 5,Date_rb + 42,
IIF(WorkDays = 6,Date_rb + 35,
WorkDays = 7,Date_rb + 30))
Assuming all work centers work at least 5 days. Premise is (30 / # workdays) X 7.
Part not worked out....adjusting for starting day of week which is probably weekday # (from formula) plus/minus some constant. Today being a Monday or a Friday might make a difference in the number of work days.
Then use the resulting date in the filter. Again, this is "an approach" not a tested solution.

ReqDate from Order Release? Then link to job via JobProd table.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of amfabllc
Sent: Monday, January 08, 2007 2:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] workdays formula in report builder



I need to make a report builder report, in it I need to use '30 days
from today'. I would really like to use the production calendar in
Vantage if possible so that once the report is finished, as long as
they keep the calendar up to date, the report will be correct.

I am in the ProdCal table, I understand Sun=1, Mon=2, etc...

Can someone give me an example of what to use for a filter line for:
ReqDate <= 30 workdays from today

I will also need to link it to the job due to I will need filter for
engineered but not release. Any suggestions? Is there something else
you guys use? Vantage 5.00.329.

Thanks,
Ann







[Non-text portions of this message have been removed]
What's really scary is that I follow you. Years ago I made a chart
of what you are talking about and wrote a few reports from it -
hopefully I still have it somewhere. I just searched and read 9 old
posts, and I must say this looks the most promising. I thought I
probably overlooked the prodcal when I wrote that years ago, but I
guess not. I am on 5.0, is there something prettier to work with to
link to the prodcal in 6.1 or 8.03? Thank you very much for your
help, at least I know what direction to go now.

Ann

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@...> wrote:
>
> I don't have it all worked out but one approach....(certainly not
elegant)
>
> 1. For the Work Center add up the # of actual work days in the
week:
> Day1 = IIF(WorkWeek[1],1,0)
> Day2 = IIF(WorkWeek[2],1,0)
> etc.... then WokDays = Day1 + Day2 + Day3 etc....thru Day7
> 2. 30-Workdays-Out =
> IIF(WorkDays = 5,Date_rb + 42,
> IIF(WorkDays = 6,Date_rb + 35,
> WorkDays = 7,Date_rb + 30))
> Assuming all work centers work at least 5 days. Premise is (30 /
# workdays) X 7.
> Part not worked out....adjusting for starting day of week which
is probably weekday # (from formula) plus/minus some constant.
Today being a Monday or a Friday might make a difference in the
number of work days.
> Then use the resulting date in the filter. Again, this is "an
approach" not a tested solution.
>
> ReqDate from Order Release? Then link to job via JobProd table.
> -Todd C.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of amfabllc
> Sent: Monday, January 08, 2007 2:19 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] workdays formula in report builder
>
>
>
> I need to make a report builder report, in it I need to use '30
days
> from today'. I would really like to use the production calendar in
> Vantage if possible so that once the report is finished, as long
as
> they keep the calendar up to date, the report will be correct.
>
> I am in the ProdCal table, I understand Sun=1, Mon=2, etc...
>
> Can someone give me an example of what to use for a filter line
for:
> ReqDate <= 30 workdays from today
>
> I will also need to link it to the job due to I will need filter
for
> engineered but not release. Any suggestions? Is there something
else
> you guys use? Vantage 5.00.329.
>
> Thanks,
> Ann
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>