Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter for actual hours by week

Status
Not open for further replies.

RoarinDave

Programmer
Apr 29, 2006
4
US
I know there has to be a simple answer to this, but here goes. I need to filter a view that shows me only the tasks that have had actual work applied within a certain time frame.

I have looked at the filters, but I can't seem to filter based on timescaled data. Maybe I am making this alot harder that it really is.

Can someome help point me in the right direction

Thanks,
David
 
Can't be done without some VBA.

Get date range.
Loop through the resources
Look at the TimeScaleData for Actual Work for that date range.
If <> 0 then set flag1 to yes else set it to no
end loop
Apply a filter based on Flag1
 
Loop through resources? Sheesh. Loop through TASKS. Sorry.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top