Myriad_Rocker
06-24-2008, 09:09 AM
I was hoping you guys could assist me in figuring this little thing out. I have a form for work request submissions. Here's a highlight of the opportunity.
User opens form
User selects a date range via a calendar (used the API calendar)
User selects a recap schedule (Daily, Weekly, Bi-Weekly)
Recap schedule written to schedule table
So, there's more to the form, but that's the quick and dirty of my issue. I need to figure out how to determine the dates that fall in the selected recap schedule based on the start and end date of the work request.
Also, I would like to be able to keep them from selecting Bi-Weekly (or Weekly) if the start and end date do not allow it. For example, 10/12/08 through 10/18/08 wouldn't allow for a Weekly or Bi-Weekly schedule selection. It would however allow for daily. So, the daily schedule would look like this...
10/13/08
10/14/08
10/15/08
10/16/08
10/17/08
These dates are because the 12th is a Sunday and the 18th is a Saturday. Recap reports are not run on weekends because no one is in the office. So, I also need to exclude all Sunday and Saturday dates from the schedule as well.
Oh, and one more complication to throw in the mix...if the schedule is weekly or bi-weekly, recaps are done on Tuesday's only.
Hopefully someone can give me some direction. My brain seems lazy today. Well...most days, for that matter.
User opens form
User selects a date range via a calendar (used the API calendar)
User selects a recap schedule (Daily, Weekly, Bi-Weekly)
Recap schedule written to schedule table
So, there's more to the form, but that's the quick and dirty of my issue. I need to figure out how to determine the dates that fall in the selected recap schedule based on the start and end date of the work request.
Also, I would like to be able to keep them from selecting Bi-Weekly (or Weekly) if the start and end date do not allow it. For example, 10/12/08 through 10/18/08 wouldn't allow for a Weekly or Bi-Weekly schedule selection. It would however allow for daily. So, the daily schedule would look like this...
10/13/08
10/14/08
10/15/08
10/16/08
10/17/08
These dates are because the 12th is a Sunday and the 18th is a Saturday. Recap reports are not run on weekends because no one is in the office. So, I also need to exclude all Sunday and Saturday dates from the schedule as well.
Oh, and one more complication to throw in the mix...if the schedule is weekly or bi-weekly, recaps are done on Tuesday's only.
Hopefully someone can give me some direction. My brain seems lazy today. Well...most days, for that matter.