Monkeyboy126
IS-IT--Management
Hi
I have a table with many fields but I am only interested in 2 (Date opened & date closed).
! !
! !
x-----!--o !
! !
! x--------o !
! x-----!-----o
! !
!<---this period only--->!
! !
So on the above diagram (if it displays correctly) x=open date and o=closed date. The period that i want to report on may be a week, month etc (as displayed above) and should include calls in an open state but opened before the period, calls opened and closed in the period and finally calls opened in the period but still open.
Any ideas, I'm really struggling with this one...
Regards
Paul
I have a table with many fields but I am only interested in 2 (Date opened & date closed).
! !
! !
x-----!--o !
! !
! x--------o !
! x-----!-----o
! !
!<---this period only--->!
! !
So on the above diagram (if it displays correctly) x=open date and o=closed date. The period that i want to report on may be a week, month etc (as displayed above) and should include calls in an open state but opened before the period, calls opened and closed in the period and finally calls opened in the period but still open.
Any ideas, I'm really struggling with this one...
Regards
Paul