Filter: today plus # of days

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Project
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Adding Notes to Reports I'd like to add some notes to the bottom of a report (explaining the abbreviations that I've used). I tried adding notes to the Left Hand Footer, however, only three lines are allowed. What other options do I have for doing this? Thanks, KellyB Tag: Filter: today plus # of days Tag: 78696
  - 2
    - Global.mpt is corrupt. My global.mpt seems to be corrupt. MSP crashes when loading from the global.mpt. I have made some changes to macros, so it would be valuable to me if I could recover the global.mpt Any help is much appreciated Tag: Filter: today plus # of days Tag: 78693
  - 3
    - General Overview?? I am not that familiar with Project, can anyone tell me if Project would work well in the following situation. Keep tabs on 30 running projects with various amounts of overlapping time schedules. Can you track both labor and non-labor resources to prevent overlaps? Tag: Filter: today plus # of days Tag: 78692
  - 4
    - Where do I get a 120 day eval key for MS Proj 2002? The key the install is trying to use doesn't work. Tag: Filter: today plus # of days Tag: 78690
  - 5
    - Overallocation warning stuck I've got two resources that are showing in red and their Overallocation field is yes, however, they do not show an overallocation in the Resource Usage view. I go back to the start of my project and click 'Next Overallocation' and get a message that there are not overallocation. Looking at the Resource Graph, these resources do not show any overallocations. What is going on? Thanks, KellyB Tag: Filter: today plus # of days Tag: 78689
  - 6
    - Filter on Split Tasks I have a number of split tasks throughout my project. Is there a way to filter on those so I can see them all. Tag: Filter: today plus # of days Tag: 78688
  - 7
    - Times not calculating - Urgent! Project 2003, new user to MS Project I have built a project plan and put in some task and subtasks and it does not seem to be calculating properly. For example, a main task heading is "Create Speadsheets", where the total should calculate beside as it is in bold, then the 3 subtasks below which have the following times, .25h, .25h, and .5h. This should total 1 hour, but the main task shows .5 hours. I have checked the rest of the project and it also seems to be doing the same thing. It is not calculating the .25h properly. Is there some setting I am missing? Any help would be greatly appreciated as I have 2 plans to get out in the next 2 days. Thanks so much in advance. Shauna Tag: Filter: today plus # of days Tag: 78677
  - 8
    - Filtering deliverable by dates At present, I have deliverables that can be filtered by this week, next week, this month and so on. Would that be possible to set up the filter that uses from the current calender date. For example if today is Feb 28 and I filter by "this month" I would like to see all deliverables for one month starting today not just the deliverables for the remining of the month which is Feb. 28 in this case. I hope there is a solution to this. Sorry, by an error I have posted this question in project server Regards, Majid Tag: Filter: today plus # of days Tag: 78676
  - 9
    - In Project, customize report layout re: wrapping fields? I'd like to be able to fix report layout problems in Project 2003. I'm used to using Access and setting up my own reports. I'm hoping to be able to output these to Word or Excel so the data can be communicated to the non-Project running world. Can you export a filtered result to Excel? There seem to be a lot of templated options, but none of them are flexible and inclusive enough for my use. Tag: Filter: today plus # of days Tag: 78673
  - 10
    - Start versus Actual Start... Here's where I stand... 1) Tasks entered (all fixed units/non-effort driven), tasks linked, time estimated, resources assigned at 100%, resources leveled 2) File has been baselined 3) Project has begun TRACKING IS MY PROBLEM: My approach is simply to ask each resource to let me know on a weekly basis the date they start (on each task), the # of hours per week for that task, and the date they finish. Of course some of my tasks have multiple resources assigned - still, they each report separately and when they are ALL done, the WHOLE task is complete. THEN THINGS DON'T GO AS PLANNED (as they do in any project)... Still, all I want to do is enter the above info as it is provided to me but many, many times the dates start playing "tricks" on me. I had assumed that my baseline would tell me the story of how things didn't go as planned as compared to actuals. So, my question is what is the difference between "Start" and "Actual Start"? This seems to be at the core of my problem. I at least know that neither of these dates are the "Baseline Date". Am I missing some basic concept here? Help! Kevin Tag: Filter: today plus # of days Tag: 78666
  - 11
    - Project Server - Executive Summary Hello, We've installed Project Server 2003 with the hopes that the executives will be able to to see an overview of all projects (in progress and in the pipeline), and their status. Does anyone know of a good method, or report available in Project Server 2003 that will accomplish this for us? Or at least give us a starting point? Thanks in advance. Tag: Filter: today plus # of days Tag: 78658
  - 12
    - Changing a task's duration I am adapting a Project Professional plan that someone else created. Tasks, durations and start/finish times were already entered, but resources were not. I have now specified resources and working times. When I try to add resource names to a task, however, it changes the start and/or finish date. Even when I open the task information and delete the duration, adding a resource alters the start/finish date. I have increased the resource's working hours to 1000% just to see if that is what is causing the task dates to change, but it doesn't help. Does anyone know what is going on, or what I am doing wrong (or not doing)? Thx Tag: Filter: today plus # of days Tag: 78656
  - 13
    - How 2 resolve circular reference I am unable to add a successor to a task because it says it would create a circular reference. I am having trouble tracing through all the relationships by hand. (This is a big, complicated file.) Is there a tool that analyzes task relationships and that could show the path to the potential circular reference? Tag: Filter: today plus # of days Tag: 78655
  - 14
    - MP Best Practices Iâ??m currently on the hunt for some best practices information that can help direct me down the right path. I am currently in a small-medium size organization that utilizes Microsoft Project to assist in managing projects. We use Project Server as a central point to manage the resource pool. Each Project Manager is responsible for managing there own resources. Our resources are often shared across multiple projects, so to ensure that we are not over allocating any one person at a corporate level, we use the levelling function. Understanding that levelling only ensures that resources are not over allocated, we need to then ensure that at each levelling point we â??clear levellingâ?? to maximize resource utilization or else MP will just push tasks to the next available point and ultimately blow out the project plan. However, by using the â??clear levellingâ?? function we are effectively freeing up time previously utilized which could be taken by another project if they are levelling at the same time you are and with the same resource needs (if that makes any sense). This could be a common scenario when auto-levelling; something we are currently grappling with. This is really a timing issue but a very likely one unless MP has safe guards in place to protect from such a thing. I have also noticed that the clear levelling/levelling combination does not maximize resource utilization to its full potential. Iâ??m guessing itâ??s probably not the right tool for this but would appreciate some direction on how best to do this. What Iâ??m looking for is some industry best practices to address: ï?? Shared resource management and the industry standard on controlling over allocation. Assuming levelling is the only answer then that leads to the next bullet. o Auto-levelling vs. manual levelling and maintaining resource control in a shared environment. ï?? Maximize resource utilization Direction to a whitepaper on MP or similar would also be helpful. Tag: Filter: today plus # of days Tag: 78654
  - 15
    - Suspending a task assignment Does anyone know of a way to effectively "unassign" or otherwise prevent a resource from continuing to charge time against a task once their duties are completed? (We're using Proj Server 2003.) Thanks for any help! Tim W. Tag: Filter: today plus # of days Tag: 78651
  - 16
    - Error when saving project Hello NG. We use MS Project 2002 (no server) and the following message appears, when saving a project: "The instruction at "0x3019dcdb" referenced memory at "0x00000000". The memory could not be "read". Click on OK to tetermin the program Clik on CANCEL to debug the program" Does anybody know what this message could mean? Thank you Sylvia Tag: Filter: today plus # of days Tag: 78649
  - 17
    - Resource Availability Setting vs. Leveling I'm having a bit of trouble using the Resource Availability setting for personnel in a project. I have people who will be available 100% then 50% of the time. I set the parameters for each person then leveled my project. Any tasks that were set to resource usage of 100% were not scheduled while the person was at 50% on the schedule. If I make the person available only 50% of the time using their calendar it levels just fine. It does appear that if I change the resource usage on the task from 100% to 50% it will level properly. however, that sort of defeats the purpose since I would like Project to figure what tasks can be done during the time the people will be 50%. Is there a way to set their availability to 50% and have the tasks schedule properly without having to change the settings on the task? Tag: Filter: today plus # of days Tag: 78648
  - 18
    - Project Links With Excel Hi, I have a strange problem - I copy and paste special - paste link dates from Microsoft Project to Microsoft Excel. This has worked fine until recently when any new links I try and paste just return #N/A. Is there a way that I can remove all link references from the original project and start again? It says that I am on link 1320 but this appears to be because all previous links have been used from my original project (the one I use now is a save as from the original but time adjusted for this year. Any help would be most appreciated Regards Andrew Tag: Filter: today plus # of days Tag: 78641
  - 19
    - 24 hour working I'm presently trying to set up a normal shift-working pattern to include dayshift and nightshift how do you do this. Project doesn't seem to recognise a shift working pattern from 19:00hrs to 00:00 and from 00:00hrs to 07:00hrs. I keep getting the message "Start of shift must be later than end of previous shift". Timescale is set in hours. Tag: Filter: today plus # of days Tag: 78638
  - 20
    - Showing % complete on baselines We are trying to update progress in MS Project. What we want to do is have both the task bar and the baseline for the task visible. We have done this successfully, and our baseline is a hollow block. We want to be able to fill in the baseline according to the percentage completion of the task, regardless of any changes we may make to the actual task duration, start, or finish dates. This requires another bar style and originally this was done, with the bar starting at the baseline start and ending at the physical percentage completion. This only works correctly if the baseline and the task bar have the same start and end dates. As soon as dates, or durations are altered, it no longer does what we want it to. If we have 25% of the work complete for a task, we want 25% of the baseline to be filled in, regardless of whether the durations, or dates are of baseline and current plan are the same. The only way we seem to be able to this, is by customising fields to calculate the percentage complete as a duration of the baseline and then adding it to the baseline start date. Tag: Filter: today plus # of days Tag: 78633
  - 21
    - Can I use small business server to host project server? Hi, My question is. We are a group of 5 users who'd like to setup a project server and be able to have access to the server from anywhere. What would be the needs (Apps) and setup? Thx Tag: Filter: today plus # of days Tag: 78631
  - 22
    - Global.mpt Hi, I have this situation where my boss installed Microsoft Office Project Standard 2003. The problem happened whenever he wants to start using it, where suddenly there is an error message prompt saying that couldn't find the global.mpt file. Any idea. Thank you ini advance. Ally Tag: Filter: today plus # of days Tag: 78628
  - 23
    - Message displayed while opening the microsoft project 2003. There are multiple lines of text in the existing note. If you change the note here, all lines of text except the first line, and all formatting, will be removed. If you do not want to lose any text or formatting, edit the notes by clicking the Notes button on Standard toolbar. Do you want to change the not anyway? Tag: Filter: today plus # of days Tag: 78627
  - 24
    - Produce resource usage report in specific format I need a report which: Scans the Tasks names assigned to a resource to produce a resource usage report in the following format... Resource name Task name 12/2 13/2 14/2 15/2 16/2 17/2.............. Joe ------------------------------------------------------------------------------------------------ Task1 X X X X Task2 X X X X Fred ------------------------------------------------------------------------------------------------ Task2 X X X X X Task3 X X X In the project Task1 may repeat as a task name but with different dates so I would like to boil all the assignments for resource to tasks with the same name but different dates down to a single line. The existing Resource usage report displays each task assignment and date as a new line on the report so it doesn't quite porovide what I'm looking for. I need the report for an automatic rostering application of project. Tag: Filter: today plus # of days Tag: 78625
  - 25
    - Combining Resource and Task Tables Is there any way of inserting a text field from the resource table into the task table? Thanks Renee Tag: Filter: today plus # of days Tag: 78622
- Next
  - 1
    - pegar celdas rellenas desde excel directamente al Gantt Trabajo mucho con Project, brindo asesorias y trabajo en esto todo el dia. He encontrado un problema comun en los equipos multidisciplinarios y me gustaria verlo solucionado en Project. La mayoria de las personas programan actividades en excel (esto en su fase de PlaneaciÃ³n) y rellenan las celdas con color para indicar la longitud de las tareas a las cuales asignan cualquier unidad, por lo general semanas, para ellos es lo maximo dado que es como interpretan su Work Flow, ademÃ¡s no todo el mundo tiene project en su empresa, pero si tienen Office! Seria bueno poder copiar las celdas que ellos rellenan en excel (en donde cada celda es una unidad de Tiempo) y pegarlas directamente a la Vista gantt en MS-Project ,el cual deberia ser una rejilla totalmente manipulable, y a partir de esto project deberia calcular las fechas, basado en la Iniciacion del proyecto y la unidad de tiempo asignada, Esto permitiria tener un Project de doble via, una la del profesional que integra los datos tecnicos en project y otro del que se toma la informaciÃ³n primaria. Tag: Filter: today plus # of days Tag: 78621
  - 2
    - MS Project Actual vs Planned duration and effort I have a situation which I would like to capture in my schedule. Planned Start Date : 02/16/2005 Planned Finish Date : 02/18/2005 Planned Work : 24 hrs Actual Start Date : 02/16/2005 Actual Finish Date : 02/21/2005 (resource has not worked on the task in between) Actual Work : 24 hrs When I am trying feed in data, system is changing effort to 32 hrs. I would like system to change "Unit" not "Duration/Effort". I tried with "Fixed Duration" as well as "Fixed Work" Type. Appreciate suggestions. Tag: Filter: today plus # of days Tag: 78620
  - 3
    - Recurring Tasks I am wondering what is the best way to use 2003 to schedule recurring meeting where the dates of the meetings may change. I have a project which stretches about 3yrs. I used the recurring task to preliminarily schedule the meetings which occur bi-weekly. I then altered the dates for a few of the meetings. Now I want to add additional meetings to the reccurrence list, but every time I try it resets all my existing meeting dates back to the preset default reccurrance. It would be nice to be able to keep meetings dates all on one line and still have the flexibility to change or add meetings without affecting the whole line. Any help would be appreciated. Tag: Filter: today plus # of days Tag: 78619
  - 4
    - Enterprise Projects 2003 How do I dynamically link fields between different Enterprise projects??? I am trying to compile a high level project based on an assortment of lower level projects. Tag: Filter: today plus # of days Tag: 78611
  - 5
    - Is Project Server Needed for Sharing? We have a small workgroup of about 5 users that would like to use MS Project. We own Project 2002. Is it possible to share projects, schedules, etc. amongst these few machines with MS Project 2002 (i.e having the files reside on a network share)? Or is this something that requires the Project Server? If someone could tell me, in a nutshell, what the basic differences are between the MS Project and MS Project Server, I'd be very grateful. Thanks, Brian Tag: Filter: today plus # of days Tag: 78609
  - 6
    - Customizing reports in Project 2002 We have an integrated master schedule with subprojects inserted. Each project is work for various organizations. We have inserted a column in the IMS and labeled each task an organization. We are using one resource pool for all projects. We need a report that tells us the total work hours by month for which organization by resource. We have a who does what when that totals hours, but now we need to add for WHOM. Tag: Filter: today plus # of days Tag: 78606
  - 7
    - Display non-dependent external tasks? We have a master schedule (Prj2003) that includes certain milestones that we would like to display in a number of "external" schedules. These milestones are not predecessors of any tasks in those schedules, and the external projects are not sub-projects of the master schedule. Is there a way to link milestones from the master schedule to an external schedule so that changes to those milestones would show up in the external schedule? Thanks Dave Tag: Filter: today plus # of days Tag: 78603
  - 8
    - Simple Gantt Chart In MS Project - Newbie Please excuse what may be an incredibly stupid question. I'm a database developer, and well versed in my apps, but Project has me stumped. Perhaps I'm trying to kill a fly with a F22. I'm importing into MS Project from Filemaker Pro via ODBC a database of about 150 seperate projects that we track. Pretty basic fields in the database for each project: Job Location, Job Description, Project Manger, Planning Start Date, Planning End Date, Bid Start Date, Bid End Date, Construction Start Date, Construction End Date, Project Manager Comment. All I want MS Project to do is import the data of all the fields above, and plot them on a big Gantt Chart (we have BIG plotters to print). Smith Bldg Fix Door Steve 10/1/2004 10/3/2004 10/8/2004 10/12/2004 11/1/2004 11/15/2004 custom door job and then the next job, the next job, etc. . For the life of me, I can't seem to make this happen. I can get the ODBC to import, but everything ends up with a little chart of just today- instead of the days I specify. Any direction greatly appreciated! Tag: Filter: today plus # of days Tag: 78602
  - 9
    - Sound in safe mode? When i run my computer in safe mode, there is no sound. Is it possible to activate sound in safe mode, for example when wathcing movies or listening to music in realplayer/mediaplayer? Please help me, thanks! Tag: Filter: today plus # of days Tag: 78601
  - 10
    - MS Project - Master/sub-Project dates Hello, I am having the same problem as Camille, who posted a question regarding the project dates for inserted projects (see 11/17/2004 message MS Project). Camille wrote: While trying to create a Master Project, I keep encountering a strange problem. I insert a project and it automatically has a finsih date for 1/24/06 (which is the finish date of the master project assigned automatically by MSProject) I have to expand the subtask in order for the correct date to show up for that particular project, and this happens for every new project I enter on my Master project. Then once I have done that there are other times that the dates change back to the 1/24/06 date on every project and I have to go back and expand each one for the correct dates to show up again. Hope this makes sense and does anyone have a solution. As she did, I also confirmed that the project is scheduled from State Date. I find that if I "Select All", then select "Show All Tasks", all the inserted projects will revert to their correct dates. But this isn't a practical solution for making sure someone opening the master project file will see the correct dates. Any suggestions? Tag: Filter: today plus # of days Tag: 78599
  - 11
    - e-mail via MS Exchange server for select project resources I have set up views for proejct resources to be alerted when certain conditions apply, such as late tasks. I want to alert the recipients via email using MS Exchange Server. How can I accomplish this? Tag: Filter: today plus # of days Tag: 78593
  - 12
    - does Project have XSLT and XML? I notice Office apps such as Word and Excel have the XSLT language so you can write XSL documents to transform data to other applications. I could not find this information on the MS Project home page. Tag: Filter: today plus # of days Tag: 78592
  - 13
    - Can I import or export to other programs? My accounting department uses Quickbooks for our purchases. Can we export the vender, customer, equipment and various other information to Microsoft Project? Tag: Filter: today plus # of days Tag: 78591
  - 14
    - Is there anyway to HIGHLIGHT a field or words in MS Project 2003? I am wanting particular fields to stand out in a project plan. I know that you can change the font color, but that isn't what I'm really wanting. Was hoping the whole field could be highlighted like in other MS products. Tag: Filter: today plus # of days Tag: 78589
  - 15
    - lost notepad how would I reinstall notepad on my computer? or the command to expand the file from the windows xp cd i am just looking for the basic notepad that gets installed with windows, where would I find it? Tag: Filter: today plus # of days Tag: 78580
  - 16
    - Using a project template downloaded from Microsoft I am running project 2003 and would like to use a project template from microsoft. I downloaded the template. When I try to change the dates or duration they are always grayed out. How do I unlock these fields so I can put in my own dates? Tag: Filter: today plus # of days Tag: 78569
  - 17
    - adding resources Hello, I was wondering when planning a project how you would add a resource part way through a task. I know you can go to the resource availability chart and make it unavailable until a certain part of a task. But, I want the resource working 100% on one task, and when that task is complete, to work 100% of the time on another task that is part way complete when he rolls over. Any help would be greatly appreciated Scott Tag: Filter: today plus # of days Tag: 78564
  - 18
    - resource pool data is getting duplicated the data in my resource pool is getting duplicated the data copies itself any solutions? Tag: Filter: today plus # of days Tag: 78563
  - 19
    - Calender Hi, Please forgive me before I start!! I have a user who is using Tracking Gant. There is a column called start - with dates in. When he clicks on the toggle a calender appears, from there he tries to change the date to 2006 but as he gets through the months ie november 05, december 05, then it loops back to Jan 05 & not Jan 06 as I would expect & as other users which it does. Have checked any obvious settings but unfortunately I am no expert in Project so any help would be appreciated. Thanks in advance James Tag: Filter: today plus # of days Tag: 78560
  - 20
    - RE: View Tasks Somehow one of the Task has duplicated subtasks name. How can I remove one of them? This is viewing from PWA. For example: Task Name Work % Work Complete Administrative Time 8h 0% 3004 Administrative 4h 0% 3004 Administrative 4h 0% How can I remove the second "3004 Administrative" ? TIA Johnny Tag: Filter: today plus # of days Tag: 78557
  - 21
    - HELP!! -- Calendar Formatting Two quick questions for which I can't find an answer in my copy of the Project Bible. And, of course, I need the answers 20 mins ago ;-) Any help is greatly appreciated! Both are concerned with the calendar view, in particular. 1) Is there a way to set groups of tasks (assigned to different teams, for example) so they display on the calendar view with different color bars? That way, at a glance teams could determine the crap that they need to pay attention too amidst all the other stuff.... 2) When I view the calendar on my computer screen, the is a *very* slight gap between the edges of the bar for a task an the gridlines for a particular day making it easy to distinguish one day from the other. When I PRINT the calendar, however, the task bars run right up to the date gridlines with no breathing room. Is there any way to make the format on paper match the visual on my monitor? (Please note, BAR ROUNDING is selected for all these tasks... It needs to be beacuse if we turn it off, thenames of tasks get so truncated we can't tell what's what) Thanks! Tag: Filter: today plus # of days Tag: 78553
  - 22
    - display the note column Hi, I accidently posted this in the developer section but think it should be here. Just wondering how to display a note column (has a note icon) with tasks that have notes, and also displays a check with completed tasks with project? I had this set up previously but can not recall how to get the display setup. thanks. -- Paul G Software engineer. Tag: Filter: today plus # of days Tag: 78551
  - 23
    - Linking Milestones from individual plans into a master milestones I am trying to link milestones from several individual plans into one milestone plan. The aim is to have sections in the overall plan for each project, linked where there are dependencies between those projects. When a milestone changes on an individual plan then it will automatically change the milestone on the master plan. I have tried using the "links selected fields dynamically between project plans" in help. This seems to allow the task name to change dynamically but does not change the date dynamically....any ideas? Tag: Filter: today plus # of days Tag: 78549
  - 24
    - Unknown start Dates I would like to enter dates which are driven by the customer, and which I have no controll over. Is there any way to put them on the task list, but not show a start or finish date? Tag: Filter: today plus # of days Tag: 78548
  - 25
    - Can I link MS access table into MS project as tasks? Is it possible to link an MS access table into MS project as tasks? I know I can import it but I would really prefer to link. Tag: Filter: today plus # of days Tag: 78547

Hi,

I'm trying to create a filter that shows me tasks that are schedule to
*start* in the next 4 weeks. I've tried to create the following
filter:

Field Name: Start
Test: Is less than or equal to
Value(s): today+28
AND
Field Name: Start
Test: Is greater than or equal to
Value(s): today

Project doesn't seem to like "today+28" -- so I'm obviously not doing
this right. Any thoughts on how to make this work?

Thanks in advance for your help!
Tommy

Re: Filter: today plus # of days by John

John
Fri Feb 18 11:18:44 CST 2005

In article <pan.2005.02.18.14.21.10.612689@yahoo.com>,
Perfect Reign <theperfectreign@yahoo.com> wrote:

> On Thu, 17 Feb 2005 13:51:06 -0800, tmann donned fireproof underwear and
> scratched on the wall:
>
> > Hi,
> >
> > I'm trying to create a filter that shows me tasks that are schedule to
> > *start* in the next 4 weeks. I've tried to create the following
> > filter:
> >
>
> Just curious - have you had any luck with this yet?
>
> This would be a useful feature for me. I've been printing tasks out in
> this format using the print dialog box, but it would be nice to have such
> a filter.
>
> TIA

Perfect Reign,
Are you asking a question here? There is so much other "stuff" in the
post, we can't tell what you need.

John
Project MVP

Re: Filter: today plus # of days by tmann

tmann
Fri Feb 18 14:01:02 CST 2005

Yes, I finally figured out how to do this.
1) create 2 customized date fields (Tools -> Customize -> Fields)
2) Formula for Date1 should be Now()
3) Formula for Date2 should be Now()+28
4) Create a filter where Start is <= [Date2] AND Finish is >= [Date1]

Thats it.
Tommy