i tried it on the demo and it works.
but i still cannot find the reason why on my scheduler is not working.
i am using exactly the same sql for both viewing on the browser and for export.
on the browser it works fine and when i do export some of the events (not all of them. it depends from the time) are not shown. if i do some changes on the StartTime and EndTime of the event then it is shown.
on the sql i use datetime.