Hi,I need to create a Leave Request Database. I have a from date and to date. How wil I display all of the days on leave on a Calendar view and skip the weekends?
Subject: Leave Request
You are going to have to create the array of dates, and check each day using the weekday function to see if it is Saturday or Sunday, to not include that in the list.
If you have the money, I suggest you look at www.departmentcalendar.com, their software is relatively inexpensive, and does this vacation/time off bit really well, and some of the other tools have value added on this as well.
I don’t work for this company, but I am currently evaluating their software.