Determining if given day is a non-work day
Hi Mike,
First, just a thought: Using the help in the object browser will save you
ages of time.
As I do not use these objects frequently, I just went there myself.
Now to your question:
Activeproject.basecalendars("Standard").period(startdate,finishdate).working
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620
Quote:
> Jan,
> How do you identify the name of the calendar? for
> instance if the name of the calendar is "Standard" and I'm
> looking to see if 12/25/2002 is a working day or not, how
> would I phrase that in the code?
> Thanks,
> Mike
> >-----Original Message-----
> >(the nameof theCalendar).Period("the dateyou
> wanttocheck").working
> >HTH
> >--
> >Jan De Messemaeker
> >Microsoft Project Most Valuable Professional
> >Project Management Consultancy
> >Prom+ade BVBA
> >32-495-300 620
> >> Hi everyone,
> >> Does anyone know how to determine if a given date is a
> >> working or non-working day according to the standard
> >> calendar? I have a macro that assigns timescaled work
> >> against assignments, but when it runs into a day that
> is a
> >> non-working day (such as a holiday), it blows up. So, I
> >> need to incorporate something into the macro to
> determine
> >> if the day is a nonworking day or not and if it is a
> non-
> >> working day, proceed to the next available day.
> >> Thanks for your input!
> >.
