We are storing the dhtmlx schedule data per samples and documentation. This works great. However, we would like to come up with a database query and\or server-side code that will tell me all of the events that occur on a given day. This is easy for non-recurring events. However, for recurring events I am looking for a way to parse the rec_type to help answer this question.
Anyone have a sql query and\or regular expression or code snippet that will tell what recurring events are scheduled to happen on a given day?
Thanks,