Complicated Date Query

A

Alex

I'm not sure if I should post this in programming. Here is the problem. I
have a table that holds the fields requestID and date the request ID was
assigned. Now that ID will be shown the next day but with a different
date..It will keep showing up everyday till that request ID is completed. So
if Request 234 was assigned 10/16/2004 and completed 11/01/2004. That ID
won't show with a 11/02/2004 but show 234 10/16/2004, 234 10/17/2004...and so
on. Now I want to be able to see how many days it took to complete that
request. I would normally subtract the max Date of Id - MIN date of ID...but
the MAX ID of date for today..doesn't mean its completed for some request.
So first I have to distinguish which IDs is completed from what ID is still
going on..Not sure how I'll do that..please if you need more clarification
let me know. Believe me the way this is being done I believe is ridiculous
like my boss..ha
 
M

Mike Schlosser

Don't understand exactly what your doing, but you will need to know the
completed date, then you can look at that
for your comparison.

You may be able to count the number of records per request ID, since each
represents a day.
Sounds like a mess.
Why not have one record per request with a start date, end date, request id,
etc,
 
Top