A
Austin
Hi everyone,
I need some help on something that I have been asked to do
but am finding difficult.
I need to count the number of different cases in every
month, I can count the ones that have start and end dates
but find it immpossible to count the ones that have no end
date (cos they are 0) meaning that they are open.
I have tried to use an array incorporating the OR function
but can't get it to work.
Below is an example of what I am trying to achieve.
Count table based on data below.
1/4/04 1/5/04 1/6/04 1/7/04 1/8/04 1/9/04
31/4/04 31/5/04 30/6/04 31/7/04 31/8/04 30/9/04
Case1 1 1 1 1 2 1
Case2 0 1 1 2 2 1
Case3 1 1 1 1 1 1
Case4 1 1 1 1 2 2
Cases - Sample Data
Start End
Case1 1/4/04 1/8/04
Case2 31/5/04
Case1 1/8/04
Case3 31/4/04
Case2 1/7/04 18/9/04
Case4 1/4/04
Case4 1/8/04
Can anyone help me?
Regards
Austin
I need some help on something that I have been asked to do
but am finding difficult.
I need to count the number of different cases in every
month, I can count the ones that have start and end dates
but find it immpossible to count the ones that have no end
date (cos they are 0) meaning that they are open.
I have tried to use an array incorporating the OR function
but can't get it to work.
Below is an example of what I am trying to achieve.
Count table based on data below.
1/4/04 1/5/04 1/6/04 1/7/04 1/8/04 1/9/04
31/4/04 31/5/04 30/6/04 31/7/04 31/8/04 30/9/04
Case1 1 1 1 1 2 1
Case2 0 1 1 2 2 1
Case3 1 1 1 1 1 1
Case4 1 1 1 1 2 2
Cases - Sample Data
Start End
Case1 1/4/04 1/8/04
Case2 31/5/04
Case1 1/8/04
Case3 31/4/04
Case2 1/7/04 18/9/04
Case4 1/4/04
Case4 1/8/04
Can anyone help me?
Regards
Austin