J
Jon Fernandez
Hello,
I need to apply a date filter to my project via a Visual Basic macro. When I
apply it from the Menu Project->Filters->Date Interval and two date selection
dialogs appear, it works fine. It shows any tasks that starts, ends or lasts
during the given interval.
The problem is when I try to call FilterApply from my macro.
Sub FilterByPastCurrentNextMonth()
Dim a As Date
Dim b As Date
a = DateAdd("m", -1, Date)
b = DateAdd("m", 1, Date)
FilterApply Name:="z Date Interval", value1:=a, Value2:=b
End Sub
These two parametres don´t work well, because when I call this function, the
gantt chart only shows tasks that lasts or finishes during this interval, but
if it starts between Date "a" and Date "b", it does not appear.
The Project version I'm using is Project 2003 Professional (SP2).
What am I missing? Are the parameteres wrong?
Thanks in advance
I need to apply a date filter to my project via a Visual Basic macro. When I
apply it from the Menu Project->Filters->Date Interval and two date selection
dialogs appear, it works fine. It shows any tasks that starts, ends or lasts
during the given interval.
The problem is when I try to call FilterApply from my macro.
Sub FilterByPastCurrentNextMonth()
Dim a As Date
Dim b As Date
a = DateAdd("m", -1, Date)
b = DateAdd("m", 1, Date)
FilterApply Name:="z Date Interval", value1:=a, Value2:=b
End Sub
These two parametres don´t work well, because when I call this function, the
gantt chart only shows tasks that lasts or finishes during this interval, but
if it starts between Date "a" and Date "b", it does not appear.
The Project version I'm using is Project 2003 Professional (SP2).
What am I missing? Are the parameteres wrong?
Thanks in advance