Can you please clarify what the "Course_End_Date" and "Course_Start_Date" are used for? I followed all the other fields and their purposes, but I want to make sure i grasp what you need the two above fields to communicate to you.
And how long is a Course? Does that factor into any of this? And are the courses given at particular intervals or terms?
Thanks for your response.
The 'Course_Start Date' is entered when a student enrols as it is the date they start their course.
The company want to calculate the 'Course_End Date' to indicate when the course expires.
A course is two years but a student can defer for upto a year and have an extension upto a year (sometimes they may only have a month, sometimes the whole 12 months).
Does Course_Entension Period count days or months? If months, are these calendar months or 30 day intervals? (Not all months are the same number of days.)
If I read your description correctly...
A student starts the course on 1/1/2010. They have until 1/1/2011 to complete the course unless...
They file for an extension. That changes the expiry date to 1/1/2011 + the extension
They defer the course, that adds 1 year to the expiry date.
Thus, in rough outline, Start date + 2 years + extension + 1 year if deferral = Expiry date.
Its not quite that simple:
A student starts the course on 1/1/2010. They have until 1/1/2012 to complete the course unless...
They file for an extension. That changes the expiry date to 1/1/2012 + the extension
They defer the course, that adds how ever long they defer to the expiry date.
Therefore I solved it with the following calculation:
Course_Start Date + 730 + Course_Extension Period Days + Course_Deferral Period
Couse_Extension Period Days = Course Extension x 31
(Uses If(not IsEmpty))(The company will forgive a day or two)
Course_Deferral Period = Course_Reinstate Date - Course_Deferral Date
(Uses If(not IsEmpty))
Thank you for all the help.