I want to write a simple query to retrieve all the activities for a single resource by date range. The problem arises in the reoccuring activities, and calculating them. Before I try to delve into that code and figure out how to return multiple rows for each reoccuring acitivity, has anyone else already done this?
Hi,
Can any please help me to use GetAppointmentsForDate() method? I want to retrieve the appointments for the next 7 days. It works fine in the start of the month. But it breaks at the end of the month.
For Example if I created the activity from the 30 October 2012 for the no end date, then it fetches the appointments till the 4th of the November. What to do to fetch the data next from 4th November?
Please help me if anyone knows the trick to fetch the data. I am badly stuck.
Thanks,
Originally I thought I would have to write an SQL statement to retireve the data. But I found the GetAppointmentsForDate function on the WebScheduleInfo object that would give me the same information. I was just trying to create a list (grid) of the events for the next 30 days. This function works great for that.
Thanks for responding.
when you say query do you mean the database or the object?