Calendar: Start Date, End Date & everything in between
I'm looking to create a calendar that will display all active employees in a company for the date selected. The only fields I have to work with is the Start_Date & End_Date in the Employee table. I want to create a calendar object where if I select a day it will show me all employees where:
Start_Date <= selected date <= End_Date
Is that just a matter of setting min date as the Start_Date and the max date as End_Date in the master calendar script? Or do I need to create a variable?