Hello all

I'm working on a milestones report where each job will have 8 different milestones/events, each with a date and time of when they were completed. I'm then working out the time difference between these milestones compared to our target times.

The problem is when I introduce a date parameter it may cut out some of the first milestones of the job as they were not within the required date range so I can't work out the time difference for the first milestone that falls within the date range.

Is there any possible formula I could insert which would say if one of the milestones for a job falls within the date range then show all of the milestones for this job?

Thanks in advance

Edited by Eoghan Murray - 18 Sep 2013 at 1:28am