Course Scheduler Dates

[josebetzy]

I would like to display (generate) the dates (weekdays selected) between two dates in a table and then use these generated dates for attendance on each of these days.

Example: The school term starts 11/9/2009 and ends on 2/19/2010. I would like to check (select) the days the class will be scheduled and enter the start and end time. Lets say I check Tue and Thu for the class ENG 101 which will start at 8:00am and end at 10:30am or 2.5 hours for one day. How can I generate a table with all the Tuesdays and Thursdays with their calendar date so that; 1) I may total the number of hours for this class for this period and add another day and time should it be less that the required hours and 2)I may be able to use this same table to later mark if the student is absent, tardy etc. for that given day. I need to exclude those days marked as holiday from a Holiday Master. Thanks.

[Søren Dyhr]

You would hopefully not ride the same day as you saddle? It's quite a comprehensive solution to be honest.

But let me provide you with a link to some other links I suggest you to follow, in order to read up on the issues involved:

http://www.fmforums.com/forum/showpost.php?post/277515/

--sd

[josebetzy]

Thanks for the guidance. The first link is not available anymore or at least from where I live it is not accessible. Being in Puerto Rico is somewhat hard to find help with such an application. But anyone willing to try their hand we would be willing to pay. And yes it is somewhat complex but only from the point of relationship. Perhaps looking at another approach might bring us some light. Thank you.

[comment]

It doesn't look complex at all: you need a looping script that creates a new record if StartDate's day-of-week is in the list AND StartDate is not a holiday. Then bump StartDate up by 1 and exit the loop when you pass EndDate.

See also:

http://www.briandunning.com/cf/452

[josebetzy]

Thanks for the link. This definitely has helped out greatly. We used one of the prior links to build a holiday schedule which was quite easy. Now we are tying this script to build the class schedule to make sure that the hours the class is supposed to be attended matches with the day and hour schedule. At the same time, the schedule it has built of days to attend we will use to enter attendance and absence. Unfortunately for us, this is a large school that only their accrediting agency requires them to enter attendance this way rather than enter only the absences. Thanks much and once we finally get it to work fully we will let you know to say thanks again. But any other suggestion, advice etc. is more than welcome.

[josebetzy]

I would like to count the number of example: Tuesdays between two dates. I would use this to calculate the other days of the week as well between two dates. Thanks.

[comment]

I would like to count the number of example: Tuesdays between two dates.

That seems like a different question. Anyway, if you have defined the WeekDaysInRange() custom function, then

ValueCount ( WeekDaysInRange ( startDate ; endDate ; 3 ) )

will return the number of Tuesdays between startDate and endDate.

[josebetzy]

Thank you for the quick response. We have already figured out the previous thanks to the examples suggested. The reason to have this was to let the coordinator know how many days (say a Tuesday) in the term would be available in order to start assigning the duration of a class and that it should meet the number of class room hours that the class has. The help has been great and we thank you much.