Viewing ETC in the past

[Paul/C.]

Am trying to create a simple view to show tasks with ETC in the past.
I can get the tabular view to show Work and Actual Work and obviously the
ETC is the difference between them. Is there an easy way of filtering to just
show those tasks where the values differ (ie there is ETC). Then someway to
filter on just displaying tasks prior to today (or a set date) ? Perhaps a
macro can do all of this, but I'm a novice in this area.

 

[Jan De Messemaeker]

Hi,

The filter is called Incomplete Tasks.
Yes I once wrote a macro to select only those with remaining work in the
past

This is the heart of the code:

atask.flag1=false
if atask.remainingwork>0 then
if atask.actualwork=0 then
if atask.start<VBA.Date then atask.flag1=true
else
if atask.resume<VBA.Date then flag1=true
end if 'Actual Work
endif 'remaining work

This has to be embedded in a for each loop, and a filter on Flag1 has to be
set up
HTH

 

[Paul/C.]

Having just started to pick this up again, I've now been advised that we
cannot create macros as this part of MSP is locked down. The bigger the
company, the more its standardised ! Does anyone know the formula in
'Customize Fields' where I can assign the date of last Friday into the
'Date1' field. Ie if today is Wed 22nd June, Date1 will contain Fri 17th June
and if today is Friday 24th June, it'll still contain the 17th, only updating
to the 24th from the 25th onwards. I know it'll be a mash of date components
and such and posting here may elicit a quicker solution to my trail and error
approach.

 

[Paul/C.]

This seems to do the trick :
Last Friday = ProjDateSub(Now(),Weekday(DateAdd(D,1,Now())))
at least on paper; now to put it into MSP !