Thank you Peter, but the problem is that once I select a specific Recruiter the Min/Max dates change to the Min/Max appt_date associated with that Recruiter.
For example, I select the year 2010
- the min/max dates are 1/1/10 and 12/31/10; and,
- the # of weeks is 52
Next, I select recruiter Anthony, Susan. Because appt_date is associated with CalendarDate, the time period changes to the specific min/max dates associated with Susan's appointments within that time period. So,
- the min/max dates change to 3/9/10 and 12/28/10; and,
- the # of weeks, calculated based on these new min/max dates, is 42
What I'd like is for the number of weeks to be based on all of 2010 (i.e., 52) - and that # should be dynamic based only on the selected time period. Without defining a static period of time and hard coding the divisor, I'm not sure that it's possible, but it is the requirement.
Any other ideas?