I have a schedular which is used to store the staff appointment details.
I also have a dashboard module which has a grid view control to show all the appointments based on the date criteria given on dashboard.meaning if the date selected is 20 March 2011 ,then show all the appointments on the dashbaord which is Scheduled on 20 March 2011.
When a new appointment is created then its appoiintment is stored in a table named "AppointmentSchedular".If the appointment is a recursive appointment then the recursive information is stored in RECDATA field of the AppointmentSchedular table as Follows.
DTSTART:20110411T063000Z DTEND:20110411T073000Z RRULE:FREQ=WEEKLY;UNTIL=20110419T000000Z;INTERVAL=1;BYDAY=MO
What i want is when a new appointment is created which is recursive,then I need to show the recursive appointment on the grid view on Dashbaord Page.
Eg:I created a recursive appointment of a staff on 11 April 2011. The Appointment is Daily basis till 15 April 2011.
So now what i need is, to show this particular appointment from 11 April 2011 to 15 April 2011 on the dashboard.
Urgent Help Needed...