thesuggs76
Board Regular
- Joined
- Nov 15, 2006
- Messages
- 247
Hi There
I'm working with a table that has a list of the different referrals. They have a start date and an end date. I'm trying to work a way to count all the number of referrals that have been received during a certain time period for each individual. The data only looks at those who have been discharged during a certain time period.
If I'm looking at the number of referrals for the period of 01/01/12 -> 31/12/12 some of the referrals made would have been before the 01/01/12 I don't want to include those it is only where the referral date is between the time period. I also need to count the number of days between start and end date. However if the referral was made before the start date I need to start the count from the start of the period. For example if Joe Bloggs was referred on the 10/12/11 his start date would be 01/01/12. So it would be 0 referrals and 365 days.
Any suggestions would be much appreciated??
I'm working with a table that has a list of the different referrals. They have a start date and an end date. I'm trying to work a way to count all the number of referrals that have been received during a certain time period for each individual. The data only looks at those who have been discharged during a certain time period.
If I'm looking at the number of referrals for the period of 01/01/12 -> 31/12/12 some of the referrals made would have been before the 01/01/12 I don't want to include those it is only where the referral date is between the time period. I also need to count the number of days between start and end date. However if the referral was made before the start date I need to start the count from the start of the period. For example if Joe Bloggs was referred on the 10/12/11 his start date would be 01/01/12. So it would be 0 referrals and 365 days.
Any suggestions would be much appreciated??